Auto update sheet from source files

[colinheslop1984]

I have a spreadsheet which consolidates information from several other spreadsheets. This 'master' spreadsheet collects all the data from the source files fine as long as they are open, but doesn't when they are not.

These source files are working documents. Is there a particular format they need to be saved in thatwill allow the information to automatically pool in to the master sheet, withoutme having to keep opening them all just to update this one master sheet?

 

[psulions83]

It may just be a setting in your Trust Center in excel. Try this OPTIONS >>> TRUST CENTER >>> EXTERNAL CONTENT. See if those settings are set to DISABLE for both. When I tried this it updated for me and my settings are on the PROMPT USER for both.