Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.

learn more… | top users | synonyms

0
votes
2answers
1k 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
1answer
374 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
392 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
365 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 ...
0
votes
1answer
37 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 ...
0
votes
3answers
8k 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 ...
0
votes
1answer
519 views

SharePoint 2007 List export to Excel 2007

Good Morning, I exported the contents of a SharePoint list to an Excel worksheet; however, I noticed the colors and formatting that have been applied to the data. This was done automatically as a ...
0
votes
1answer
137 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
1answer
216 views

Migrate Excel Docs from Shared Drive to Sharepoint Foundation 2010?

I have a fairly large shared drive with various files that need to be migrated over to SharePoint. I only have full control of my site, which is a subsite within the hierarchy. I feel like if I were ...
0
votes
2answers
2k 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
1answer
2k views

Simultaneous working with Excel in SP2010

Is it possible to work with multiple users simultaneous on the same excel document in SP2010? If possible without the excel web app. Extra... Is it possible to work with different versions then? ...
0
votes
1answer
909 views

Tracking Changes to Individual Cell in Excel Spreadsheet on SharePoint?

I've gotten a weird request today, someone I work with asked if there is any way to track changes to a specific cell in an Excel Spreadsheet. The spreadsheet is hosted on SharePoint and they want to ...
0
votes
1answer
2k views

Getting rid of the session timeout in Excel Web Access?

I understand there is a 30 second short session timeout (if no interaction is detected) to a 5 minute extended sessiopn timeout. The userss would like their reports up all day, just refreshing every ...
0
votes
1answer
7k views

Cannot open file using Edit options

We recently had a few users in our environment upgrade to Excel 2010 and all these users are now experiencing the same problem where they cannot edit files by clicking them in the library or using the ...
0
votes
1answer
1k views

How to manage a dynamically updated Excel file in SharePoint

When we have a client that requests a call back, we fill out a web form that automatically populates an excel spreadsheet on a shared drive. Reps will then access the spreadsheet and take appropriate ...
0
votes
1answer
114 views

What is the best option you would use to show dashboard data within an Excel file on SharePoint?

What is the best option you would use to show dashboard data within an Excel file on SharePoint? A. SharePoint and MS Office Integration. B. SQL Reports integrated with SharePoint. C. ...
0
votes
3answers
8k views

Export list with attachments

We have a legacy Sharepoint Services 2.0 server where users have been maintaining a few custom lists. There are items in these lists that have attachments (Word, Excel, PDF type documents). Over the ...
0
votes
1answer
207 views

SharePoint 2007 and Large Excel files

I have a user that has create an Excel file, the file has 16 tabs on it, and 14 of the tabs are graphs and the last two 15 & 16 tabs are pivot table that control the graphs. Tab 15 pivot tables ...
0
votes
1answer
2k views

Can SharePoint 2010 Monitor Class Attendance and Activities?

The organisation I represent is a coaching company, with a number of coaches spread across the globe. One of the spreadsheets they use most frequently is a tracking sheet for all the people they ...
0
votes
2answers
1k views

How to customize SharePoint Chart web part

I want to customize SharePoint chart web part programmatically to display charts from the excel sheet having different charts on different sheets of the excel. How can I customize chart web part so ...
0
votes
2answers
1k views

Is it possible to link a chart in a Word document with an Excel Spreadsheet in SP 2010?

I have a word document which contains some charts based on data in an Excel spreadsheet. I update the word document frequently (it is as status report) by editing some of the supporting data in the ...
0
votes
1answer
519 views

Excel 2003 compatibility with SharePoint standard edition 2007

I'm hoping someone can provide me with some good information/links with regards to the compatability/limitation of sharepoint standard edition and Excel 2003. I've searched all around google and ...
0
votes
2answers
272 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
1answer
585 views

Is it possible to set up an ODBC connected Excel spreadsheet on SharePoint 2007 with a Standard license?

I know that many database connections are possible with the Enterprise version of SharePoint Server 2007. Is it possible to make a custom solution to set up a connection? If it depends on the type ...
0
votes
1answer
778 views

Export an agenda in a meeting workspace

I have a meeting workspace with a recurring meeting. (WSS 3.0 hosted by Network Solutions) When I export the agenda to Excel I get the previous agendas as well as the one for the selected meeting. ...
0
votes
0answers
6 views

Cannot Copy and Paste in SharePoint 2007 datasheet view

I currently have office 2013 and I have been copy and pasting into a datasheet view list for SharePoint 2007 for a long time. All of a sudden I cannot paste any values into my list. the load wheel ...
0
votes
0answers
5 views

How to get the Last Modified Date and Time of an Excel file in a Sharepoint using VBA?

i am creating a macro file with command buttons that when you click it, it will display the properties esp the last modified date and time of an Excel file uploaded in a SharePoint site. How can i do ...
0
votes
1answer
22 views

Export SharePoint list to Excel - How remove column Item Type and Path

When I export a SharePoint list to Excel using the built-in functionnality, it also exports two columns called "Item Type" and "Path". Is there a way OOTB or programatically to exclude these columns ...
0
votes
1answer
12 views

Limit users to their own employees

I have a list of about 1000 employees with their addresses and phone numbers which I want to upload to a 2007 SharePoint in list format, which I know how to do, however due to data protection, ...
0
votes
0answers
18 views

Creating a file via VBA leads to Check-in Stalemate

We have Sharepoint 2010 Enterprise. I want to create a series of workbooks for salespeople, each one personalized, and with a different name . I want to have check-out enabled on the target doc ...
0
votes
0answers
12 views

problem with exporting sharepoint 2007 list to excel spreadsheet

I have a user who wants to be able to export data from a document library to a spreadsheet. This should be a simple matter of clicking the actions menu and selecting 'Export to Spreadsheet' and when I ...
0
votes
2answers
39 views

How to import MS Excel data into an exisiting SharePoint List?

Is it possible to import an excel list or excel data into a SharePoint List that has already been created? Not create a new list. I know you can import a spreadsheet which will create a new list, but ...
0
votes
0answers
26 views

SharePoint 2013 Excel WebPart

I created new excel webpart. I got this error : The trial period for SharePoint Server has expired. I researched on net and i found this solve : Run--> inetmgr-->Application Pools--> ...
0
votes
0answers
38 views

How to avoid authentication prompt when opening XLSX document on anonymous site?

I have a SharePoint 2013 that is setup in anonymous mode (at the web app level and then at the site level; the Entire Web site is being exposed as anonymous). I then have the "lock-down mode" feature ...
0
votes
1answer
19 views

Excel Cell Link to InfoPath sending data to SharePoint

I want to be able to send out an Excel file with a list of clients and use that file to be able to open up a form when they click on a client. The form would be pre-populated with information from ...
0
votes
2answers
22 views

Show SharePoint columns in Excel sheet

How can one show columns from a SharePoint document library into an Excel sheet. Properly with VBA, but I don't now how?
0
votes
1answer
14 views

ExcelWebPart Issue

I'm using ExcelWebpart in my page and I defined permissions on the webpart. Some users can edit the excel webpart. They click "OPEN IN EXCEL" and then they can edit. But today when they click on the ...
0
votes
0answers
10 views

Syncing Sharepoint 2013 List from Excel 2010 spreadsheet?

So i'm trying to figure out a way in which I can append items within my SharePoint list by inserting the data from an Excel Spreadsheet. However, the SharePoint list has additional columns which are ...
0
votes
0answers
12 views

SharePoint 2013 online List export to excel with views as worksheets

I have a client that would like to export a SharePoint List to Excel but to also include the views as the worksheets. How would I go about implementing this? Is this even possible? The data would ...
0
votes
0answers
46 views

Error when trying to reference an excel sheet inside SharePoint document library “The file name, directory name or volume label syntax is incorrect”

I have the following :- SharePoint document library. Inside the document library i have; Visio diagrams + excel sheet. now i am using an Add-in inside the Visio drawings to reference the Excel sheet ...
0
votes
1answer
7 views

Convert Sharepoint webpart 2013 to 32 bit version

Are there any ways to convert the visual webpart to 32 bit version. I have target in the property project c#, but I couldn't add the webpart to page. What I meant is in my case: I open excel file by ...
0
votes
1answer
38 views

Excel Linked Cells

I have the following use case: Two Excel documents are stored in the same folder on a shared drive (a typical SMB Share). The workbooks are linked through a single linked cell. If you open both ...
0
votes
1answer
63 views

Open a link of Excel with the dialog popup window in quick launch SharePoint 2010

I have a Excel document in the Library SharePoint 2010. And I set "Open in the client application" in Library setting. Every time I open this document, there is a popup window with a question "How ...
0
votes
0answers
7 views

Excel Services Problem

one of our client was adding Excel access webpart to his site and when he clicked on Edit webpart properties, he is not able to see all the properties of Excel access webpart which he should see. When ...
0
votes
0answers
36 views

“Open In Excel” button inside the Xlviewer.aspx page return Error and I can not open excel using local office

Inside the xlviewer.aspx page of sharepoint 2013 when I click on "Open In Excel" at first I receive this Error: Some files contain viruses that can be harmful to your computer. it is important to be ...
0
votes
0answers
19 views

Give Permissions to the Excel WebPart

I created a new webpart page with ExcelWebRenderer. I want to give edit permission to a group for the excel page. Other persons have read only permission for this excel page. I created a group and I ...
0
votes
0answers
8 views

Copying part of Excel workbook to a different workbook in SharePoint 2010

I have a rather simple task, at least by the description. Let’s say I have a File A (xslb) on SharePoint A and I need to copy out some data from File A to File B. File B is xslx document on a ...
0
votes
0answers
18 views

How to export SharePoint 2007 AD Accounts to Excel

Is there any way to export SharePoint 2007 AD accounts to Excel? I know that there are couple of ways to export SharePoint Userinfo list to Excel. But i want to export SharePoint 2007 Active Directory ...
0
votes
1answer
15 views

Display a Excel Chart

I'm using sharepoint for my team, and i would like to dispalay charts which update daily from my data connections. Currently i use a images and update daily, i want to automate this by hosing the ...
0
votes
1answer
142 views

Getting fully qualified FieldUserValue instead of actual user name from SharePoint

I'm working on my first C# program, and it's a pretty simple program that uses a view of a SharePoint page to go through and delete things that are older than 5 days on that page. Before deleting the ...