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

learn more… | top users | synonyms

0
votes
1answer
361 views

SharePoint 2010 - Calculated Column w/ Hyperlink & IF Statement

I am having some trouble getting this to work. I need to create a hyperlink in a column and learned that if you put some html into a calculated field and format it as a number then it works. For ...
0
votes
1answer
37 views

SharePoint Server 2013 questions

I'd like to know three things about MS SharePoint Server 2013. As I'd like to simulate the version that enterprises are using, is the SharePoint Server a good version to simulate an Enterprise ...
0
votes
1answer
40 views

Advise on how to share excel with other users

I am looking for advice on how to resolve the following issue. As part of a volunteering project I have automated an Excel spreadsheet using VBA. I have written a lot of code that includes user forms ...
0
votes
1answer
1k 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 functionality, it also exports two columns called Item Type and Path. Is there a way OOTB or programatically to exclude these columns from ...
0
votes
1answer
26 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
131 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
921 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
69 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
116 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
18 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
1answer
18 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
1k 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
540 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
67 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
37 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
32 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
145 views

How to exctract filtered items from SharePoint List to Excel

I'm using Javascript and AngularJS to get all data from a SharePoint list in JSON and displayed it into a table. User can sort it, filtered it and etc. There is a really nice paggination. Everything ...
0
votes
0answers
72 views

when user chooses Edit in Excel the spreadsheet just hangs trying to open

A user has complained that when they try to open an Excel spreadsheet on SharePoint by choosing 'Edit Workbook' then 'Edit in Excel' it tries to open but just hangs. This happens for any Excel ...
0
votes
0answers
108 views

Update Excel document without checking in and checking out

Suppose we upload a shared Excel document in the SharePoint 2013. If we try to edit it allows to edit for a windows user and allows to save it. If then another windows user tries to edit the same ...
0
votes
1answer
59 views

Can I extract a list with a button in infopath 2010?

I'm working on sharepoint 2010. I want to know if it's possible to create a button which extract the list the infopath is based on in an excel sheet. Thanks.
0
votes
1answer
763 views

Unable to update an excel file in SP

One of our users is currently trying to update an excel file that is saved directly to our SP document library. Whenever he tries to update it and save it the changes for some reason never save. It ...
0
votes
0answers
35 views

how to change the headers of a list exported to excel?

I want to use the sharepoint 2013 feature exporting to excel from a list but I want to change the name of the fields, how can it be done?
0
votes
1answer
313 views

Quick edit List URL field

I need to use the quick edit on a Link List (I am copying data from an Excel file). I am having trouble with the URL field, I can easly insert the URL but I don not know how to insert the URL name. ...
0
votes
1answer
47 views

How can I know what was modified in an Excel file hosted on a SharePoint site?

Currently, I have an alert set up so that if someone modifies an Excel file I receive an e-mail. It works fine. However, I can I tell what was modified when I go back to check on the file?
0
votes
1answer
710 views

Exporting discussion board with all the replies

Is there any way to export a discussion board to Excel with all the replies? I've tried clicking on Export to Excel from the ribbon, but what I get isn't what I want as this does not give me the ...
0
votes
1answer
157 views

Excel file which have macro enable not opening in IE

I've a requirement in which an excel file( Macro Enabled) is stored in SharePoint 2010 and when user clicks the file, it should open in the IE as read only file. The Excel file is opening in the IE ...
0
votes
1answer
19 views

Caluclated Field/Formula: Automated Month Counter

I have a "Start Date" field and a "Months in Process" field. Upon changing the start date, I need the "Months in Process" field to start ticking from 0 and increase in increments of 1 month. Everytime ...
0
votes
2answers
624 views

Excel document opening in web view even though default is to open in program

I have a document library with one Excel spreadsheet in it. The document library's settings are such that the spreadsheet should be opening in each client's Excel program, not in Excel Web View. I ...
0
votes
1answer
162 views

Generate ppt slides from Sharepoint data

There is a form in SharePoint and I need to generate an one page Powerpoint slide using some data from that Sharepoint list. I'm thinking about creating a template in Powerpoint. Let's say there will ...
0
votes
1answer
197 views

Is permission level affecting Excel links from updating?

I have some Excel documents on a Sharepoint site. I added some links to other Excel documents on a network drive. When I open the Excel files on the Sharepoint directory, they update just fine. ...
0
votes
1answer
67 views

How to save a ExcelBook generated using ExcelTemplate on SharePoint2013 Cloud

wbook.SaveAs("c:\\temp\\blah", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, ...
0
votes
1answer
145 views

How to work with Excel in c#?

I have a template/format in excel which has to be used to generate salary slips. I have saved it in a document library and using interop, open an instance of it in a workbook programmatically. After I ...
0
votes
1answer
147 views

Populate an excel object with List entry items

I have a requirement that requires generation of an Excel document programmatically in SharePoint. I need to use an Excel template that has labels like Name: Designation: Email: I have a list with ...
0
votes
0answers
23 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...
0
votes
1answer
260 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, ...
0
votes
1answer
387 views

Filling SharePoint Calendar List With Bulk Data(About 3000 Entries)

I want to fill about 3000 entries in a SharePoint calendar List for testing purpose. I have tried using this link but i have some lookup columns and person/group fields which do not appear in the ...
0
votes
2answers
10k views

Trouble opening Excel Document

I have Microsoft Excel 2007 and am trying to open and edit a document from my Employer's SharePoint (I am not sure what version of SharePoint they are running, unfortunately). I have attempted to ...
0
votes
1answer
47 views

Faster way of Downloading Metadata in CSV

we Have document library with 3lacs+ items. we have to download metadata of each file in a csv such as Modified date , modified By etc. I used powershell code for achieving this task but for some ...
0
votes
1answer
136 views

SharePoint 2007 - Users losing data in excel files

We have a SharePoint 2007 in our environment and our users are reporting that they will make changes to excel files and will go back the next day and the changes will be gone. This happens randomly ...
0
votes
2answers
448 views

Synchronize excel file with SharePoint online list

I want to synchronize data from excel file with SharePoint list on office 365. I have already built a utility which uses client object model to achieve this but it is very slow as item count are in ...
0
votes
0answers
110 views

How to synchronize an excel spreadsheet with SharePoint 2010?

I have a spreadsheet being fed by several SQL Queries. After the queries are run, the fields repopulate and I have Graphs/Charts and formulas that visually display the data. I'm trying to simply ...
0
votes
1answer
1k views

Dashboard from Excel file with Data Validation and Protected Sheets

I want to create a dashboard in Sharepoint using data from Excel Workbooks. Each Workbook has 2 sheets: Data and Dashboard. The Data worksheet contains raw data and the Dashboard tab contains KPI's ...
0
votes
2answers
2k views

Rich Text field in Infopath customized form adds blank lines in Excel

I have a fairly basic custom list in Sharepoint 2010 which contains a rich text field. I have customized the form with Infopath. Now when I export to Excel I find blank lines preceding the text. ...
0
votes
1answer
684 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 ...
0
votes
1answer
82 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
4k 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 ...
0
votes
1answer
47 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
1answer
185 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 ...
0
votes
0answers
292 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
2answers
30 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 ...