Questions tagged [spreadsheet]
is an interactive computer application program for organization and analysis of data in tabular form.
22 questions
0
votes
1
answer
2k
views
SharePoint list 'Export to Excel' produces a spreadsheet that when imported back into SharePoint does not retain correct Column types
Desired Behaviour
Export a SharePoint list to a CSV or Excel file in a format that can be imported back into SharePoint as a list with all Column types and values correctly formatted.
The reason ...
- 244
0
votes
1
answer
48
views
Share just one of multiple spreadsheet saved in excel on Sharepoint
Hi I have a excel file saved on the sharepoint and it has 5 spreadsheet. I want to give people access just to one of the spreasheets saved on the same excel file, is that possible?
- 3
1
vote
1
answer
37
views
Hide columns in spreadsheet/edit view (JS/jQuery/Cisar)
Hiding columns in normal view is ok using either of the functions:
function hideColumn()
{
var header = document.querySelectorAll("[displayname="Column Name"]")[0].parentNode;
var index = [].slice....
- 115
0
votes
3
answers
9k
views
Importing users from spreadsheet to list
I have an Excel spreadsheet with information I need to import to a list. The issue is that the spreadsheet includes a column of names I have to add to a column which comprises of users in my ...
- 123
1
vote
1
answer
963
views
Drawbacks and limitations of using "Import Spreadsheet" app to import an excel sheet inside my sharepoint sites
I am working on a sharepoint server 2016 on-premise server. and our customer have asked us if there is a way to import excel sheets into sharepoint sites. now i find this quick and easy way :-
add an ...
0
votes
2
answers
5k
views
'It looks like you don't have permissions' message Saving docs in library
We moved a SharePoint 2010 site to a new server and new domain. All users were migrated over to the new domain. One user, who is a member of two different domain groups, has contribute access set for ...
- 61
0
votes
2
answers
2k
views
SP Survey - Disable the export to spreadsheet action
After seeing many posts concerning permission levels (untick client integration features use), i'm still unable to disable export to spreadsheet option from the action menu on a Survey.
Here is the ...
- 1
0
votes
1
answer
556
views
Edge SharePoint Online import spreadsheet Apps
Within Sharepoint Online and Edge browser, I try to use the Import Spreadsheet app
I get the next error
I wonder if someone can help me to workaround this issue
- 209
0
votes
1
answer
155
views
SharePoint solution for spreadsheet daily planners
Does anybody have a good idea for using SharePoint (probably calendars) instead of creating what I call 'daily planner' spreadsheets like in the screenshot I've attached below. Personally I've never ...
4
votes
7
answers
38k
views
Open specific excel sheet from sharepoint URL
I have one excel with sheets ( Sheet1 and Sheet2) uploaded in sharepoint.
Requirement : to create a URL to access the uploaded excel document and open specific sheet (say Sheet2)
Any solutions here?...
- 71
1
vote
1
answer
997
views
Import multiple excel spreadsheets to sharepoint 2010 lists
I have a user asking if its possible to import an excel file with multiple spreadsheets to a SharePoint 2010 solution? Each spreadsheet should be turned into one list.
It is an autogenerated excel ...
- 11
1
vote
0
answers
702
views
How to download and upload data from an excel spreadsheet stored on a SharePoint site into a local excel spreadsheet?
I am exploring a method to download and upload information from an excel spreadsheet stored on a SharePoint Site from a VB based form in a local excel file. Can you please assist me in understanding ...
- 11
1
vote
0
answers
445
views
Import from Spreadsheet to Create List Fails in SharePoint 2010
When I attempt to import an Excel Spreadsheet to create a list, it fails with a VB error:
Automation error
Catastrophic failure
Environment:
- SharePoint 2010
- SharePoint Designer 2010
- ...
- 89
1
vote
2
answers
159
views
can I import spreadsheets into sharepoint list without excel installed locally?
Is there a way to import a spreadsheet into SharePoint List if you don't have Excel installed locally? Can Office Web Apps or even Google drive sheets be used instead of excel?
Edit: I have Excel ...
1
vote
0
answers
909
views
Issue with opening files in Excel Web App SharePoint 2013
I am receiving the below message while trying to open an excel file in a document library in SharePoint 2013.
"We're sorry. We can't open the workbook in the browser because it uses these unsupported ...
- 71
1
vote
2
answers
3k
views
An unexpected error has occurred (-2147467259) when Importing spreadsheet
I trying to Import from Spreadsheet to create a list and the above error occurs - the site is trusted and office activated - I have tried various spreadsheets so its not a number of cells issue. Can ...
- 553
1
vote
0
answers
2k
views
Feed a sharepoint list from a google sheet
I have a Google sheet that's being fed from a Google form. I am looking to import the new data into a list on Sharepoint as people continue to submit new items through the form. So far, I've been ...
- 11
0
votes
1
answer
723
views
Sharepoint Excel Logic
I have an Excel spreadsheet that I would like to import onto Sharepoint. The import/export function is easy enough to use, however the math logic that four of the cells conduct in the Excel ...
0
votes
1
answer
25k
views
Import Excel Sheet and append items to SharePoint list [duplicate]
I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server.
We need to append the data from the new excel sheets to the existing lists items of the SharePoint ...
- 369
0
votes
1
answer
952
views
Imported Excel Spreadsheet not Filtering Column
I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
- 1
1
vote
0
answers
64
views
Excel spreadsheet imported as a list into SharePoint 2010, is creating extra HTML tags
I have several lists that I imported into a publishing site on SharePoint 2010. It appears that the import process created lists with problems. All the fields ended up with extra html tags (i.e. ...
- 11
3
votes
2
answers
3k
views
Cannot import spreadsheet
When I try to import a spreassheet and clicked import after typed the Title, It says
Your browser should support ActiveX for the import operation.
I couldn't understand what here written. http://...
- 1,492