Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [spreadsheet]

is an interactive computer application program for organization and analysis of data in tabular form.

1
vote
1answer
23 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....
0
votes
3answers
634 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 ...
1
vote
1answer
458 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
2answers
2k 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 ...
0
votes
2answers
965 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 ...
0
votes
1answer
245 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
0
votes
1answer
112 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 ...
2
votes
3answers
10k 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?...
1
vote
1answer
639 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 ...
1
vote
0answers
653 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 ...
1
vote
0answers
380 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 - ...
1
vote
2answers
140 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
0answers
878 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 ...
1
vote
2answers
2k 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 ...
1
vote
0answers
996 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 ...
0
votes
1answer
567 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
1answer
22k 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 ...
0
votes
1answer
704 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
vote
0answers
48 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. ...
3
votes
2answers
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://...