Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
0
votes
0answers
4 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 ...
0
votes
1answer
724 views
SharePoint Foundation [Unable to process the request in Excel Web App]
I am encountering below error msg whenever I try to open excel file (.xls, .xlsx) in SharePoint Foundation 2010 portal. Other Office files such as word, ppt opens correctly without any error but ...
1
vote
2answers
34 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 ...
0
votes
1answer
16 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
3answers
2k views
Cannot open word document and Excel from Sharepoint 2010
I am not able to open any word documents and Excel from my Sharepoint2010 sites. I was able to open them before I re-installed everything from scratch.
When I try and open any uploaded Excel document ...
1
vote
2answers
2k views
Unable to Refresh the Excel Connection in Excel Webaccess Webpart
I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection.
It throws an error.The scree shot is attached.
I have ...
0
votes
0answers
12 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 ...
1
vote
1answer
37 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
0answers
13 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 ...
0
votes
2answers
1k views
Open docs from SP2010 in excel/word crashes
I have:
SP2010 rented from a company. 1 site collection
I have IE 9.0.8
For about a 6 months I have this consistent problem.
When I click on a Word doc or Excel doc, I get a choice to edit, I do ...
0
votes
1answer
564 views
Excel file opening in XLViewer for some users
We have a corporate internal portal with lot of subsite and document library for various department/BU.
When a user tries to open a excel file from a document library it opens in Excel client from ...
0
votes
1answer
436 views
Why are .xlsm files opened as read-only when .xlsx are not?
I have a number of Excel files attached to SharePoint 2010 records. Those with .xlsx extensions open quite happily and can be edited and saved back, but those with .xlsm (i.e. with embedded macros) ...
0
votes
1answer
41 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
1answer
521 views
Excel web part from list - Autorefresh
I am using SharePoint 2010.
I currently have a list that gets updated many times throughout the day.
I currently have an Excel Web Part with graphs and summary tables on the first tab, and its data ...
0
votes
2answers
572 views
Export SharePoint Search Results and List View to Excel
Can we export SharePoint Search Result to Excel? Note that our client is using SharePoint Foundation 2010.
I have searched the web and found a free tool that does this but unfortunately it works only ...
1
vote
1answer
3k views
Making a link from SharePoint site to Excel file on Shared Drive
Even though solution to this might not be SharePoint related, but thought to ask here anyway in case someone has some thoughts.
I'd like to make it possible to open certain Excel macro-enabled ...
1
vote
1answer
520 views
Export to Excel for sharepoint 2010
Export to excel was previously not working for clients that were using Office 2007 because we we are using claims based authentication. A few days ago a few clients noticed that the export to excel ...
0
votes
1answer
37 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
42 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
1answer
81 views
Excel Calculation Services - Excel Web Apps
We're trying to co-author excel workbooks but only have Standard CAL/Sharepoint 2010 Standard Server license. Its my research so far that to have co-authoring for Excel, we would need to use Excel ...
0
votes
3answers
4k views
Import Excel to SharePoint list -> Auto-synchonize based on Id
Are there tools available for importing an Excel file to a SharePoint list so that the various column types would be supported, and that the importing data would be synchronized based on an a value in ...
0
votes
0answers
48 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 ...
1
vote
2answers
422 views
SharePoint 2010 error when importing excel spreadsheet to sharepoint list
I get the following error when trying to import an excel spreadsheet into a SharePoint list.
"The specified file is not a valid spreadsheet or contains no data to import"
I have added this site to ...
-1
votes
0answers
74 views
How to Check if user is connected to Sharepoint using VBA
I have a Microsoft Access 2010 database published to Sharepoint 2010. I am able to use an ADO connection to connect to the database from Excel. The Excel file is not published to Sharepoint, just ...
2
votes
1answer
119 views
How to import one single row of data from excel to one list item in a SharePoint 2010 list?
I have a problem where we want users to attach a file to a new item and the SharePoint list will automatically read on row or column of data (maybe 20 cells-worth of data) and populate some additional ...
0
votes
0answers
18 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 ...
1
vote
1answer
2k views
Adding document version number on Excel Spreadsheet as label for printing purpose
I have a situation where I need to have version number on each document in version controlled document library.
Having version number on printed sheet would help to see the validity of document.
I ...
0
votes
0answers
27 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
23 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
2answers
297 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 ...
2
votes
3answers
10k views
Disable Excel Web Access?
Is there a way to disable Excel Web Access (_layouts/xlviewer.aspx) completely on a Site Collection? (SP2010 Enterprise)
I have enabled the "Open in Client Applications" feature and it works fine in ...
0
votes
2answers
96 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.
3
votes
3answers
8k views
Update List from Excel using VBA
I'm in the enviable position of having to support a client who wants to maintain and manipulate a complicated business spreadsheet in Excel, and then push a selection of that data to a list in ...
0
votes
2answers
207 views
Fail to export custom SPList to Excel
Im trying to export a SharePoint-List(created from a custom Listdefinition) to Excel by using the "Export to Excel"-button on the ribbon. It works when im trying with other default SharePoint-lists ...
0
votes
2answers
148 views
How to prevent users from getting at the source files for Excel Web Services
I have a request to put a large Excel dataset on a MOSS 2007 sharepoint page.
The XLSX is about 13 MB in values alone - about 50,000 rows. It's updated weekly, usually in batch form (i.e. some ...
0
votes
2answers
25 views
French excel numbers being changed to english when uploaded to SharePoint, how to fix?
I have a site where I've uploaded an excel document that was translated by one of the companies we use and once I uploaded it to my SharePoint site but the column that contained numbers changed to ...
0
votes
2answers
4k views
Export Survey Results to Excel option not in Action Menu
I have a survey and all the needed results. I need to export the results to excel, though in the process of setting up the survey I changed or removed the Overview.aspx page/view. Now when I add a ...
2
votes
1answer
38 views
Creating lists within lists, or tables within lists, or…?
I have just started working with a company on a variety of different IT issues, mostly Sharepoint 2010. They are going to contract a Sharepoint developer to help with a problem they have been having ...
4
votes
4answers
5k views
How to migrate a 2007 sharepoint list to 2010?
We have a list in sharepoint 2007 that we need to move to another site which is based on sharepoint 2010.
what's the best and fastest method?
thanks in advance
1
vote
2answers
147 views
Import a single row from Excel spreadsheet
I'm currently trying to copy a single column from an excel sheet and import it in an existing list on sharepoint. I tried this via microsoft access, but i'm only allowed 255 characters per row!
Is ...
0
votes
0answers
46 views
Is there a way to prevent Excel Web Access from loading it's workbook on page load?
I have a sharepoint page that I am working with and it contains an Excel Web Access Web Part. That EWA Web Part is used to display and filter a large report that connects to an OLAP cube, and takes ...
0
votes
0answers
31 views
Can I export list instances as .wsp package?
We are having an issue where in our 2010 solution the list instances are populated by an excel spreadsheet import using Microsoft.Office.Interop.Excel. Unfortunately this cannot be done in the UAT ...
1
vote
0answers
66 views
Use an Access Web Database as a data source for Excel?
I have an Access 2010 Web Database published to SharePoint as described here:
http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx
If my Access ...
1
vote
6answers
6k views
Update Sharepoint list using excel
I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA).
This can be done from Access not a problem however I need it to be Excel ...
0
votes
0answers
75 views
How to import an excel spreadsheet into SharePoint Assets web database?
I would like to utilize the SharePoint Assets Web Database to track approximately 700 computers we have at our site. I currently have the information in an Excel 2007 spreadsheet, and would like to ...
0
votes
1answer
132 views
How to convert Sharepoint 2010 Chart web part to Excel?
I want to convert chart webpart's chart to excel format
how it is possible?
1
vote
1answer
357 views
Unable to refresh data for a data connection in the workbook.
I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010.
On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
1
vote
1answer
89 views
If a user can't read Excel file, can they still view Chart Web Part created from it?
Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up.
If users don't have permissions to ...
0
votes
1answer
2k views
Excel links open files as read-only mode. How to change this to edit mode?
Does anyone have any idea why using the link on excel opens the file as read-only mode?
How can I change the behavior to open as Edit mode?
I checked almost all of the Document Library settings, ...
1
vote
1answer
406 views
SharePoint List Export to Excel All Columns!
As you may know SharePoint's default export to excel only exports the columns of that current view to excel. Is there anyway to export all columns, without adding all columns to that current view.
