I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset ...

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 ...

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 ...

i've been making this formula(based on previous questions) which works great(with 3 id's), But when i try it with all my id's it give me an error "Cannot complete this action". Can anyone help me out?
...

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 ...

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 ...

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 ...

I'm using SharePoint 2007. I have created custom-list.
The list contains one column from "Person and group" type, show field: E-mail.
I fill in data in the list column and export this list to excel ...

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 ...

Do you know of any resources/solutions to enhance the List’s “Export to Spreadsheet” function so that, once the data is opened in Excel, something would trigger VBA Macro(s) to start formatting the ...

I'm working with WSS 3.0 and have access to a number of sites within SharePoint.
I and a number of other users have run into an issue that is happening when we try export a list using the "Export to ...

I have a problem in understanding what is the standard approach to follow for editing office documents inside my document library. As it seems each browser will have different behavior when it comes ...

I have several excel documents containing PowerPivot tables. They all connect to a SSAS Tabular service (on SQL 2012) via a .odc connection file, all of which is hosted on SharePoint 2013, using the ...

Posted a question yesterday and got a great suggestion to use Excel REST. I've looked at the documentation but had a basic question about how to apply it.
I've got 3 workbooks in a document library ...

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 ...

I have an alert set up for a discussion board. We have been using Office 03 just fine, email comes in, the body is shown fully, everything is great. However, when we use Office 2010, not sure if its ...

I'm trying to add a web registration form for people to sign up for a lunch and learn. The idea would be once a user presses submit, his/her info would automatically post to the Excel sheet and the ...

I read that we can store list items limitation for sharepoint 2010 is 30 million . Is this true ?
If yes , then can i have 25 million records in sharepoint list , and use "export to excel sheet" and ...

I need advice how I can fix problem with Excel external data connection.
I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. ...

I have a customer who asked a very difficult requirement and do not know if possible.
It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...

I have an excel document that is linked to a SP 2010 list.
I set the connection and the update on open.
It works just fine (i.e. updates with new data) when the file is on my local machine.
However ...

my client wants it automated so that the exported csv file will be saved periodically into a location and he can do his necessary action. rather than coming into the site and exporting it each time. ...

I have a scenario that would be perfect for slide libraries - but they're excel sheets. We use SharePoint 2010. Also, I do not have access to the server itself... Just site collection administrator. ...

Trying to build a 'generate report' link with various options. I would have three links, each with different list filtration criteria. The idea is then that whilst people are on that page, they can ...

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 ...

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) ...