I currently have two spreadsheets housed in Excel Services in a Sharepoint Hub. These two spreadsheets are linked. However, the values on my main spreadsheet will only update 1. if the source document is opened or 2. if I click the Edit Links button and then click the Update Values button. I tried clicking the Startup Prompt button in the Edit Links dialogue and selecting "Don't display the alert and update links", but that didn't work. Is there any programming that can be added to the main spreadsheet to force it to update values without needing to click on the Edit Links button and then click on Update Values? If I have these same two documents housed on my computer, the links update when the main document is open. Is there a way to get the spreadsheets to act this way in SharePoint?
Any assistance you can provide would be greatly appreciated.
How are these documents linked? If you are using external links, these are not supported.
Excel Spreadsheets that will not load on the first version of Excel Services
Spreadsheets that contain one or more of the following features will not load in Excel Services.
- Spreadsheets with code. This includes spreadsheets with VBA macros, forms controls, toolbox controls, MS 5.0 Dialogs, and XLM Sheets.
- IRM-protected spreadsheets
- ActiveX Controls
- Embedded SmartTags
- PivotTables based on “multiple consolidation” ranges
- External references (links to other spreadsheets)
- Spreadsheets saved in formula view
- XML expansion packs
- XML Maps
- Data validation
- Query Tables, SharePoint Lists, Web Queries, and Text Queries
- Spreadsheets that reference add-ins
- Spreadsheets that use the RTD() function
- Spreadsheet that use spreadsheet and sheet protection
- Embedded pictures or clip art
- Cell and Sheet background pictures
- AutoShapes and WordArt
- Ink Annotations
- Organization Charts and Diagrams.
- DDE Links
Also note that workbooks in Excel active differently than in Excel Services:
- 편집됨 Mike Walsh FIN 2011년 12월 21일 수요일 오후 5:12 SP 2010 replies are off-topic in a pre-SP 2010 forum links to sp 2010 info removed
REST is only available in the 2010 version of SharePoint/Excel Services.
You only need to worry about the browser. However, I would move from XP to W7 because it is a better OS.
Please indicate that you are running MOSS 2007.
a) confirm that you are in the correct forum
b) stop people giving you replies about functions that are in SPS 2010
If you are using Excel Services as part of SPS 2010, please say so and post your questions to the relevant SP 2010 forum for them (Setup/Admin)
SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
Both also have links to extensive book lists and to (free) on-line chapters
- 편집됨 Mike Walsh FIN 2011년 12월 21일 수요일 오후 5:15 If you are ... section added