Update Formulas in Excel Services

Question

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.

Answer 1

Hello,

Thank you for your post.

 

This is a quick note to let you know that we are performing research on this issue.

 

Thanks

 

---

Pengyu Zhao

TechNet Community Support

Answer 2

Hello AuntDi,

How are these documents linked?  If you are using external links, these are not supported.

Excel Services part 12: Unsupported features

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:

Differences between using a workbook in Excel and Excel Services

Answer 3

The spreadsheets are linked using formulas referencing each other.

 

Is the REST API only avaliable in SharePoint 2010?

 

Is SharePoint 2010 compatible with Windows XP or do you have to have Windows 7?

Answer 4

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.

Answer 5

Please indicate that you are running MOSS 2007.

That would

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

Answer 6

Yes, I am using Microsoft SharePoint 2007.