update linked spreadsheets w/o recreating links



I have 20 separate spreadsheets that are emailed to me monthly with updated
information. Every month I need to sum the data (example: add the B10s in
all of the spreadsheets). I've created a master spreadsheet linked to each
of the 20 spreadsheets, but I've found I need to recreate the links every
month. If I try resaving the new updated file over the top of last month's
spreadsheet in hopes that the link will still work, I get a #REF on the
master spreadsheet. Is there any way to create a master file with links that
will update without cutting and pasting from the 20 new files to to 20 old


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question