-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sharepoint 2010
-
D
Can you use vba code to export SharePoint 2010 list to Excel 2010?
I know you can pretty easily export/import SharePoint 2010 list data to/from Excel using "Export to Excel" ribbon interface. If there's a need to do it for a large number of files, I need to automate this process using vba code in Excel 2010. I have seen this work according to the link...- dearnemo
- Thread
- excel 10 vba code sharepoint 2010
- Replies: 1
- Forum: Excel Questions
-
R
Excel Services in Sharepoint 2010 not displaying pivot table on refresh
I have an Excel workbook published to my Sharepoint doc library and it is set to refresh automatically every 60 minutes and I don't have it set to refresh on open. When I open the workbook in my sp library I lose the fields in my pivot tables, but the data is refreshing in the rest of the...- rkamke
- Thread
- excel services pivot tables sharepoint 2010
- Replies: 0
- Forum: Excel Questions
-
D
Printing Excel 2010 Web Objects with Slicers in SharePoint in Excel 2007
We have developed dashboards in Excel 2010 with Slicers and Pivot tables and charts. we are placing these dashboards as Excel Web Ojects in SharePoint 2010. In our Organization the users all have Excel 2007. We would like our staff to use the slicers in SharePoint and then download and print the...- DrSuper
- Thread
- excel 2007 excel 2010 printing sharepoint 2010 slicers
- Replies: 0
- Forum: Excel Questions
