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
files?

update linked spreadsheets w/o recreating links
 

Hi Petersjill

Maybe you can use this every month
http://www.rondebruin.nl/summary2.htm

To get the workbooks from your mail folder try
http://www.rondebruin.nl/mail/folder2/saveatt.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Petersjill" wrote in message ...
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?