C
cksiz
I have about 85 excel files that point to 1 single source sheet. However,
each file may point to a different cell in the source, and the destination
cell is not always the same (ie A2)
I need to move the source to a different file path on the file server.
Is there an easier way to update all 85 file links, without having to open
each one, and re-point to the source file?
I have thought about a macro, however, as I said, each file may point to a
different cell, and the destination cell is not always the same.
each file may point to a different cell in the source, and the destination
cell is not always the same (ie A2)
I need to move the source to a different file path on the file server.
Is there an easier way to update all 85 file links, without having to open
each one, and re-point to the source file?
I have thought about a macro, however, as I said, each file may point to a
different cell, and the destination cell is not always the same.