G
grathkolb
I've been having this problem with a bunch of Excel documents in
various folder. Now all worksheets reside in the same folder but at
different level going no more than two levels in. However every
worksheet more than one level up references one worksheet at the folder
root. This is where all the folders draw their core values from.
There are about 30 or more worksheets that draw their values from this
file however, I'm trying to send this to a client to look at and play
with the numbers of the base file, except that every worksheet
references that base excel worksheet absolutely so the entire folder
path is the reference to the worksheet. This won't work if I'm giving
it to someone else, so is there any way to change it to a relative
reference that will reference the base worksheet in a folder below it?
various folder. Now all worksheets reside in the same folder but at
different level going no more than two levels in. However every
worksheet more than one level up references one worksheet at the folder
root. This is where all the folders draw their core values from.
There are about 30 or more worksheets that draw their values from this
file however, I'm trying to send this to a client to look at and play
with the numbers of the base file, except that every worksheet
references that base excel worksheet absolutely so the entire folder
path is the reference to the worksheet. This won't work if I'm giving
it to someone else, so is there any way to change it to a relative
reference that will reference the base worksheet in a folder below it?