View Single Post
  #2   Report Post  
Old May 22nd 06, 05:22 PM posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default Updating Links on Excel

Are you speaking about hyperlinks or a formula that directs the cell to get
data out of another file?

"Update Link Question" wrote:

I have a spreadsheet that summarizes data from 300+ different workbooks.
Every month a new file is created and we need to update the summary with the
new month data. Is there a better way to update the links on the summarizing
spreadsheet? Currently, we need to edit links and update links for each
(300+) file name. The only thing that changes in the file names is the month.
Thanks!