Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
0
votes
0answers
8 views
Combine excel workbooks via pivot table/chart?
I have created a site that has 5 workbooks all the same column headings. They have macros and validation within them and therefore cannot be viewed within Sharepoint but must be opened within Excel.
...
0
votes
2answers
19 views
ECB “Edit in Microsoft Excel” is missing for users
I have bunch of user in a SharePoint group with Special Contribute access (same as contribute permission but No delete).
These users are not seeing "Edit in Microsoft Excel" in the ECB menu. If I log ...
0
votes
0answers
12 views
Excel 2010 VBA to open most recent Major Version of Excel 2010 file held in Sharepoint 2010
I am using Sharepoint to enforce version control for a number of Excel Spreadheets. I want to use the major & minor versions feature to allow me and the development team to make changes against ...
0
votes
1answer
16 views
Search excel spreadsheet or Microsoft access within sharepoint
I have a spreadsheet with a list of batch jobs. I was wondering if it's possible to create some type of search into a sharepoint to search this spreadsheet. We are using sharepoint and if I could have ...
2
votes
0answers
34 views
We cannot locate a server to load the workbook data model
This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
0
votes
1answer
16 views
Link Excel to SharePoint 2010 list content
I have an Excel document that is linked to my SharePoint 2010 list. Recently my list climbed over the 5000 limit so I had to add some filtering to my view. This negatively impacted my Excel document ...
0
votes
0answers
34 views
Excel File Opens as an Offline Copy
For some reason, when I check out or open (Read Only) this one Excel file in a document library, it opens as an "offline copy".
The File menu in Excel says it's an "Offline Copy: Workbook is in ...
1
vote
0answers
18 views
Having issues looking at all old versions
I've been trying to look at older versions of a file but keep getting this error? Any idea what it's happening?
I've looked at the source of the document within Excel and it's looking for a copy ...
0
votes
0answers
15 views
Document properties not updated when creating a new document into a XLS templated library
I am replacing a colleague for the support of a SharePoint 2010 intranet.
I have got an issue when creating a document into a library.
The document template of the library is a XLS file (Excel 97 - ...
0
votes
0answers
26 views
Some Excel documents do not open in Excel 2010
I have a problem with .xlsx files in SharePoint 2010. When I, or other users, try to open Excel files in Excel it just says
Downloading: https://server/site/library/file.xslx
The document never ...
0
votes
1answer
22 views
Co-authoring in Excel, OWA
After installing Office Web application in my SharePoint server 2010, we are unable to co-authorise with Excel. But this co-authorise function works with Word and PPT. Is there any setting we need to ...
0
votes
0answers
11 views
Excel Web Access Error message
I use SharePoint 2007 and have used Excel Web Access to link to a spreadsheet for a few months. It's a rota so is updates every few months and all I do is change the file path to match the new file ...
0
votes
0answers
44 views
Unable to refresh SPO 2013 Excel Web external oData source
First of .. I see the Excel Web access webpart on SPO 2013, but is Excel Services available on SPO 2013 and if so, where is it and how do you enable it?
So, I have this cloud test users.
I ...
0
votes
0answers
29 views
excel odata connection to sharepoint online custom list - How do I return all rows in an SPO 2013 to excel 2013
How do I return all rows in an SPO 2013 list to excel 2013?
I'm trying other sources > odata and can get some things, but not all rows.
...
2
votes
0answers
18 views
SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO
Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph.
If so, any BI option for formating list data on an SPO page?
Possible now under SPO 2013 A3 license?
Confused about ...
0
votes
0answers
12 views
How to recover files saved but not checked in on a Mac?
I have an Excel file that I checked out and opened in Edit mode directly from Sharepoint on my Mac OSX. I was saving along the way. However, Excel then crashed before I was able to close the file and ...
1
vote
0answers
24 views
Cannot Save Excel to Sharepoint
One of my users is having an issue saving to Sharepoint with some very specific parameters.
the problem is related to saving only from within excel if a document has been opened from SP. She is ...
0
votes
0answers
24 views
Export Excel Table to Sharepoint List throwing publishing error?
I have a SP Foundation 2010 installation on windows 7.
I created a OOTB Contacts list in SharePoint and tried exporting an excel (Office 365) table with various fields to this list.
Note: The column ...
0
votes
0answers
19 views
Metadata not saving thorugh Excel 2010 on one column
Me and some colleagues are finding that when we save a document to SharePoint 2010 with Excel 2010 one of the meta data columns does not save properly. In SharePoint it says the column is empty but if ...
0
votes
0answers
38 views
Compare Date to constant using ACE.OLEDB.12 in Excel VBA
After a lot of searching, trial and error, I finally managed to come up with an Excel VBA procedure that will return date from a SharePoint list. The query works fine if I do not qualify the Select ...
0
votes
0answers
13 views
How can I modify a Excel Web Access Web Part client side?
Hello I'm just getting started in Sharepoint 2013 development.
Currently, I am trying to display a spreadsheet in Excel Web Access. The spreadsheet displayed is determined by a session variable. ...
0
votes
0answers
19 views
How to insert documentID in an excel file, for each new created excel document in a document library?
I have a sharepoint 2010 portal. I know it is possible by quickParts to insert metadata in a Word document. See also these tutorials:
...
1
vote
1answer
51 views
Why does SharePoint 2010 Excel WebPart not find Excel spreadsheet in Share Documents?
I have a SharePoint 2010 single instance. The Web site has an Excel worksheet in Shared Documents, which I can navigate to as a user.
I have enabled Excel services.
I have activated Excel services ...
1
vote
1answer
55 views
IF AND CONCATENATE Nested Statement in Calculated Column SharePoint 2010
I am having trouble nesting concatenate formula with if statement - syntax error. I am trying to create a calculated column. This column will list "master file" string if exist. If two master files ...
0
votes
0answers
19 views
Add-in disappearing from the excel spreadsheet
We have installed an Add-in to excel spreadsheet which appears on the ribbon with a new tab called 'Add-Ins'. But
we started having problems with the add-ins/macros disappearing either when a new ...
1
vote
0answers
23 views
IE crash - when copying data from Excel to Sharepoint List
I have an EXISTING SP List, and am trying to copy / paste data from an xls file into the list. I have a view created that mirrors the columns I am trying to copy in. It appears to copy / paste okay, ...
0
votes
1answer
43 views
Export all of Sharepoint 2010 data (list, webapp data, etc. )
I need to export all of Sharepoint 2010 data (list, webapp data, etc.) in to a easy to import file. Meaning I have "SiteName" with lists and webapp data, and I need all the information of that site in ...
0
votes
1answer
50 views
Sharepoint 2010 / Google Chrome / Excel
From one of our users:
Now that many of the items seem to work with Sharepoint and Chrome, one of the biggest outstanding issues is that it wants to open the documents in the browser by default.
...
0
votes
1answer
39 views
Read from an excel Sheet and write to a List
My requirement is that, i need to upload data from an excel sheet to an existing sharepoint List in SP 2010.I will have 2 different Lists Like this. Then I need to compare Both the List and retrieve ...
2
votes
1answer
95 views
Document Library containing Managed Metadata when exported to Excel has weird characters
We have document library for storing assets in it. Document Library contains some of Managed Metadata lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each of the ...
0
votes
0answers
14 views
Sharepoint 2010 issue with exporting certain combination of columns from a view
so I am encountering an issue where I am trying to export to excel..I modify my default view to include all the columns I need in the export. When I try to export, it's either hit or miss with certain ...
0
votes
0answers
63 views
Import Sharepoint (WSS3.0) List into Excel 2010 using a specific view name
I'm trying to create an Excel highlight report reading lists from a SharePoint 2007 (WSS3.0) site. This is a Excel workbook that is used as a template for different portals.
With help of this post:
...
0
votes
0answers
33 views
Excel Services - How to remove cached dataset
I need to reflect role-based security in Excel Services, but I have an issue with caching of the Excel workbooks, so a user without access to models/cubes sees the initial dataset inside the ...
1
vote
0answers
65 views
SP2103 Excel-Services Freeze Panes / Headers
Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
1
vote
0answers
31 views
Enable Publishing Options button without SharePoint Designer
We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
0
votes
0answers
9 views
How to link Excel to Acces when the files are saved on sharepoint, then refresh in Excel service
We have files in excel that are saved on sharepoint. We want to pull this into access, but when trying to link to them from access, we get a an error that they must be XML files. How can i link ...
1
vote
2answers
648 views
query a sharepoint 2010 list from excel vba to retrieve a specific record
I have created a SharePoint 2010 list with 2 relevant columns:
- Identification Key
- Version Number
I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
1
vote
1answer
23 views
Displaying Version # In Document
I am looking for a way to display the SPItem version number from within an Excel document. We are authoring an Excel Template in a version controlled document library. I want the Excel document to ...
0
votes
0answers
19 views
Publishing Named Ranges Programatically
I have a document library containing excel files with named ranges. I created some excel web parts programmtically and linked these excel web parts to my excel files in my document library.
My ...
0
votes
0answers
42 views
Data truncated when pasting worksheet into multiline field
I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some ...
1
vote
1answer
183 views
Error while opening sharepoint list in datasheetview and exporting to excel
I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error .
Below is a summary of the issue:
After selecting datasheet view :
"Cannot ...
0
votes
1answer
90 views
Error exporting list to excel - permissions for resource throttling ceiling
What level of permissions have to be assigned to a user account in SharePoint 2010 for them to qualify as an "administrator" and therefore grant them access to the higher ceiling for resource ...
1
vote
1answer
135 views
saving an excel file: You do not have the correct permissions. Contact the server administrator
a user is attempting to open an excel file from a SP 2010 library, make edits, and save it back. when clicking save, he gets this error message in a popup window: You do not have the correct ...
0
votes
0answers
112 views
SharePoint 2010 List Excel Export Error
I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
0
votes
1answer
256 views
Documents Not Prompting to Check Out and Not Saving
I am getting strange behavior on some of my users machines when they attempt to edit an Excel workbook from SharePoint. When the user clicks on the document link it opens the workbook in Excel and ...
0
votes
0answers
28 views
Autoupdate Excel Links
I'm running into issues including formulas/links into an Excel file stored on SharePoint. As soon as I download the Excel file locally to my desktop SharePoint adjusts the formulas to use the server ...
0
votes
0answers
43 views
How to automatically generate the URL for the “URL Access” of SSRS Reports in a Report Library?
This is my setup:
I've a few reports developed using Business Intelligence Development Studio & deployed on Reporting Services in SharePoint Integrated mode.
The RDL files are deployed to a ...
0
votes
1answer
27 views
Open documents in client unusual behavior
I recently modified settings at the list level to force documents to open on the client. After I tested the behavior while logged in as an Admin and it seemed to work fine.
Today however an end user ...
2
votes
3answers
3k views
Excel document opening in browser (unsupported features)
I am using Sharepoint 2010 and when users click on an .xlsx document in a document library it says the following:
"The workbook cannot be opened because it contains the following features that are ...
0
votes
2answers
956 views
Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template?
Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template? I just want to see how it works.
