Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
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
407 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.
0
votes
1answer
196 views
How to modify an Office (Word, Excel) file in sharepoint programmatically
I need to Open and modify a document that resides on a Sharepoint Document Library.
These changes on the file are done during an event generated by a Document Library, so I must change it by code.
...
1
vote
0answers
18 views
Import excel spreadsheet with photos
I am trying to import an excel spreadsheet with photos, It import without problems, except that it removes the photos.
What am I doing wrong?
1
vote
3answers
8k views
Import Sharepoint List into Excel Using VBA Only
In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes.
How can I import data directly from a Sharepoint ...
0
votes
0answers
35 views
Sharepoint link issue
I am having a weird issue. I uploaded an excel document to sharepoint, and when I click the link it does not do anything, however if I right click open in new tab it opens. ** This is an excel ...
2
votes
2answers
688 views
List containing Managed Metadata when exported to Excel using Ribbon, has weird hash tags - how to clean?
I have a calendar All Events list which contains few fields, some from Managed Metadata and People presence lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each ...
1
vote
1answer
464 views
SharePoint 2010 Issue with CSV File
We are using SharePoint 2010. I have permission (full access) on my site. I have three uploaded files (one Word .doc, one Excel .xls, one CSV .csv).
I had no problems editing Word and Excel files. ...
0
votes
0answers
78 views
Bind Sharepoint List Fields with excel columns
Hi i have to bind Excel columns to Sharepoint list Columns and my excel contains not just a simple Grid. It is a template which looks like this :
is it possible to bind this straight forward like ...
2
votes
1answer
93 views
Simple Way to Get Data from WSS 3.0 List to Excel via Web Services
Is there any simple way to get live data from a WSS 3.0 list into Excel via web services or am I going to need to write code?
I understand I can export the list data, that is far too manual.
4
votes
1answer
409 views
Run an Excel Macros from SharePoint
I was wondering if it's possible to initiate Excel macros (Excel file is located on a network drive) from SharePoint? Are there any add-in features within SharePoint that can communicate with macros?
1
vote
1answer
303 views
How to update Excel Sheet In SharePoint 2010 (Sharepoint Online)?
I am working with SharePoint Online(Office 365).
I have some Excel files uploaded in a SharePoint library and I need to update one of the file data using c# code. My solution in Sandbox solution.
I ...
1
vote
0answers
48 views
Writing excel 2003 vba to extract a Sharepoint list to Excel
I'm trying to find some Excel 2003 VBA that will let me inport a sharepoint list into Excel so that I can perform some basic tasks on that data.
3
votes
2answers
3k views
Permission levels for user exporting list into excelsheet sharepoint 2010
What are the minimum permissions needed for a users to export the list into excel sheets in SharePoint 2010?
1
vote
0answers
62 views
How to get my deleted columns back in an Excel file, that were exported from SharePoint lists
I have a list in Sharepoint, and I export it to Excel. All fields get exported, so evetything is fine. Then I deside that I for example no longer want the "Modified by" field in the excel file, and I ...
1
vote
0answers
32 views
Fact tables indicators selectors/filters in an excel report with pivot tables
I'm working in a project where I need to publish some reports based on excel pivot tables against SSAS cube. Until here everything is OK.
However, I want to know how I can set in my excel report a ...
2
votes
1answer
73 views
Can someone help me use SharePoint 2010 to do data processing?
TL;DR: I need to create a system in SharePoint in which a user uploads an Excel (or CSV) file to the site from a webpage. The site takes the uploaded document and uses it to populate a list. Then it ...
0
votes
3answers
5k views
Import from Excel to an existing list
I'm trying to import data from excel into an existing list.
I can paste one line at a time by opening the excel doc and the sharepoint list in datasheet view, but that's not very efficient.
Any ...
0
votes
1answer
48 views
How to refer to a local file for a PowerPivot datasource?
We have users trying to use Performance Point and need to point to a local PowerPivot file as a data source. The instructions state:
Type the connection string to the PowerPivot data source by ...
0
votes
0answers
102 views
Doc Library Template (Excel) cannot use macros?
So I uploaded an Excel template file to a document library so each time a new document ids created using 'Add Document' the template will be what the users fill in.
Now this template has two macros, ...
0
votes
0answers
132 views
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine [closed]
I am using this code to read excel data into sql.But i got error like this The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine .Plz give good solution for me.
String ...
1
vote
0answers
175 views
How to make a List Column link to Excel Cell
I have a SP library that lists the names of various excel spreadsheets. Each spreadsheet has a cell that reflects the percentage of completion for a project.
I also have a SP list of projects, which ...
0
votes
0answers
361 views
Unable to check-out an excel sheet from a document library in SharePoint 2010 Standard
I have a document library under my SharePoint 2010 Standard site. We are uploading Excel files to this document library to be updated by multiple users (Using Check-in/Check-out). We are using IE9 as ...
0
votes
0answers
55 views
Is it possible to sort by month name in PowerView?
Is it and if how possible to sort by month name without having to add a number in front in Powerview? I would like to change these month id's to month literals so 1 > JAN:
Screenshot 1
1
vote
2answers
189 views
Ability to migrate linked Excel spreadsheets to MOSS
Hi our finance team have multiple links to other spreadsheets within the current file server. We wish to migrate these to Sharepoint to offer them a solution via Extranet. Is this possible? There ...
2
votes
0answers
185 views
offline and online (SP 2010) version of Excel with slicer
An user uploaded Excel with Pivot that has slicer to sharepoint document library. The data for this excel coming from SQL backend.
The browser gives following error.
"The workbook cannot be opened ...
1
vote
1answer
196 views
Sharepoint Excel data table and Chart
Need help about sharepoint.
I have a table data collection currently in ms excel document look like the following image.
every last day of the week the information will be updated (append new ...
0
votes
0answers
137 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
2answers
112 views
Export SPGridView to Excel tabs
I have multiple SPGridViews on a page. I would like to export them all to one Excel document, each SPGridView on its own tab. Is this possible?
This link is a great start but does not solve my tab ...
0
votes
0answers
102 views
Any way to speed up Excel Web Viewer Web Part?
Is there any way to speed up the loading time of a spreadsheet in SharePoint 2007? I noticed that especially in IE it can take up to 10 seconds or longer but often in Chrome/Firefox it loads within 1 ...
0
votes
0answers
163 views
excel worksheet is blank when opened in sharepoint 2010
I'm running into an issue where users are trying to open an Excel 2010 worksheet by clicking a link in our Sharepoint 2010 document library. When the user clicks the link, it opens the worksheet in ...
1
vote
6answers
7k views
Importing an Excel file to a list - how to control the column types
I am attempting to import an Excel file into SharePoint using Create List > Import Spreadsheet.
Several columns are just short text fields < 100 chars and with no formatting/line breaks etc.
Some ...
0
votes
0answers
122 views
PowerPivot with MySQL connector
I have a powerpivot document using a MySQL connector and when added to SharePoint it doesn't seem to think it has a dataconnection.
Is there anyway to get this type of powerpivot document to work ...
0
votes
1answer
156 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
0answers
140 views
Show “Path” field in list view export?
I have a report from a user that claims was generated by clicking the "Export to spreadsheet" button within a document library. This report contains not only All the files and folders from a level 3 ...
0
votes
1answer
3k 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 ...
3
votes
3answers
10k views
possible ways to import an excel spreadsheet to a sharepoint 2010 list?
I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list.
I've seen on codeplex a free tool for MOSS/wss ...
0
votes
2answers
53 views
Upgraded SP Servers and now webpart can't access C drive
We had one WFE server and upgraded to 2 WFE servers with a load balancer. We are using the SharePoint Server Standard edition. Because we are using the Standard edition and do not have access to BI ...
1
vote
1answer
781 views
Recovering data from modified infopath fields?
I had built and published an infopath form to a sharepoint library and populated the library with about 50 documents(based on the template)
I modified (deletd rich text boxes and replaced it with ...
0
votes
2answers
2k views
Export to excel - large lists
I am having when Exporting large lists to excel (over 14K records). It displays “Running security Scan” at the bottom of the screen and then gives “An unexpected error has occurred. Changes to your ...
0
votes
1answer
385 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?
...
1
vote
1answer
857 views
Having trouble check in excel file in SharePoint 2010
I tried to check in the file to the site. But I got this error message
(The system cannot find the file specified (Exception from HRESULT: 0x80070002)).
I'm able to check out the file, edit, and ...
0
votes
1answer
304 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 ...
2
votes
4answers
11k views
Unable to open office files in Office client
While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
0
votes
1answer
74 views
Create Date Field when using Data Connection in Excel
I noticed that the create date field of a list item is not returned when you create a data connection to it using Excel.
The technique I am using is to go to the list and export it from the ribbon ...
1
vote
1answer
186 views
Unable to use filter or edit Excel Worksheet while opening from Excel web access?
I am able to view and filter data based off excel fileters via the Excel Web Access web part for Excel workbooks.
However, when I "open in Excel" it does not allow me to filter or edit.
Note: I ...
2
votes
1answer
872 views
SharePoint 2010 Excel Web Access “Automatically reloading workbook”
I am working with SharePoint 2010. I used an Excel Web Access web part to display an Excel Spreadsheet. So that the spreadsheet can be opened in Excel and people can do editing.
However, every time ...
0
votes
2answers
2k views
Sharepoint seeking authentication when opening Word / Excel files from website
The company I work for is using SharePoint as a CMS for it's public facing website. I recently enabled FBA (Forms Based Authentication) for the site in order to provide some user specific ...
2
votes
2answers
2k views
Working with data imported from Excel into a SharePoint List
I just imported an Excel spreadsheet into a SharePoint list, and all of my data was imported as single or multiple lines of text. While appropriate for some instances, in other cases, like a name ...
2
votes
2answers
5k views
How can I share an excel document with my team to edit?
I would like to know if something is possible and where to start.
Each day, my boss sends out a spreadsheet listing our data entry errors for the previous day. All five of us download the sheet, make ...
