Originally Posted by
outofthehat
I think you do need to link to a separate workbook (happy to be proved wrong!). This isn't a problem for the master copy of your presentation, as it'll be in the right place and always able to find the latest data.
Afterwards, if you want to use a standalone copy of the presentation, just select 'cancel' when it asks if you want to update the external links, then it'll use the latest data it had.
You now have a master which can be updated from the spreadsheet as required, and standalone copies which use the data as it was when the standalone was created.
I think that's probably the best you can do.
Bookmarks