H
hals_left
Hi , I have a workbook that references another workbook via a cell
formula:
='C:\Folder\[Workbook.xls]Sheet Name'!$M$7+F7
It is to calculate a cumulative year to date total from monthly
accounts.
I have noticed that it now changed the path if I copy the sheet to a
subfolder and open it. For example if I copy the book to
C:/Folder/Subfolder then open it, all the formula have automatically
updated to
='C:\Folder\Subfoldr\[Workbook.xls]Sheet Name'!$M$7+F7
Why should it just start doing this today ? How do I prevent it ?
Thanks , hals_left
formula:
='C:\Folder\[Workbook.xls]Sheet Name'!$M$7+F7
It is to calculate a cumulative year to date total from monthly
accounts.
I have noticed that it now changed the path if I copy the sheet to a
subfolder and open it. For example if I copy the book to
C:/Folder/Subfolder then open it, all the formula have automatically
updated to
='C:\Folder\Subfoldr\[Workbook.xls]Sheet Name'!$M$7+F7
Why should it just start doing this today ? How do I prevent it ?
Thanks , hals_left