Hi all,
Can someone direct me to the resolution to the problem outlined below.
I have a Master workbook of data, which is "saved as" on a weekly basis, to track changed across the weeks, as directed by my accounts department.
I currently have a couple of other workbooks that reference the master workbook, however, on saving as, all the formulas in the other workbooks change to the latest save as file.
Can someone tell how to lock the filename in the formulas, such that it does NOT change to the backups?
Many thanks.
Can someone direct me to the resolution to the problem outlined below.
I have a Master workbook of data, which is "saved as" on a weekly basis, to track changed across the weeks, as directed by my accounts department.
I currently have a couple of other workbooks that reference the master workbook, however, on saving as, all the formulas in the other workbooks change to the latest save as file.
Can someone tell how to lock the filename in the formulas, such that it does NOT change to the backups?
Many thanks.
