H
houghi
I need to move many Excel files from one place to another. Many of these
have links to other files in the form of:
=GETPIVOTDATA("Amount";'Y:\ALL_USERS\Statistics\2008-2009\[Individual
calculation.xls]Pivot Sales'!$H$11;"Store";Belgium;"Week";F4)
And this is one of the easy ones. Others will have if statemenets and
calculations spread over multiple excil sheets. Also the directory
structure won't be the same anymore.
Now obviously when I move "Individual calculation.xls" I will get
errors. Is there a way to do the move in an easier way, or do I need to
redo each and every file and field?
I am a bit scared to just start moving. I do not want to be needing the
restore.
houghi
have links to other files in the form of:
=GETPIVOTDATA("Amount";'Y:\ALL_USERS\Statistics\2008-2009\[Individual
calculation.xls]Pivot Sales'!$H$11;"Store";Belgium;"Week";F4)
And this is one of the easy ones. Others will have if statemenets and
calculations spread over multiple excil sheets. Also the directory
structure won't be the same anymore.
Now obviously when I move "Individual calculation.xls" I will get
errors. Is there a way to do the move in an easier way, or do I need to
redo each and every file and field?
I am a bit scared to just start moving. I do not want to be needing the
restore.
houghi