Updating Links on Excel
You could do a global change for the information you want to change or you
could put the month into a cell and give it a name. Select the cell and then
INSERT - NAME - DEFINE and give it an appropriate name.
If in your cells, you have something that looks like this:
Y:\folder1\folder2\MONTH.xls
You could change it to include
"Y:\folder1\folder2\" & MONTH & ".xls"
I hope this helps you.
"Update Link Question" wrote:
I'm speaking of a formula that directs the cell to get data out of another
file.
Thanks.
"Barb Reinhardt" wrote:
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!
|