Reply to thread

Message: [QUOTE="Petersjill, post: 3729125"] 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 files? [/QUOTE]