Linked cells ignoring the folder where the files with the same name are stored in different folders

Johnny C

Well-known Member
Joined
Nov 7, 2006
Messages
1,069
Office Version
  1. 365
Platform
  1. Windows
I have a load of models that are stored in a folder for each day. Last thing at night I create the next day's folder and copy all the files into it from that day. This is because we need to be able to track where and when changes were made. There might be hundreds of changes made in a day, too many to document manually.

There is an issue, if someone opens the file with the chart that has a ce;ll with a value
='F:\3 Year Planning\15-11-2019\[Strategic cost forecast Assumptions.xlsb]Constants'!O22
But so see what the value was a month ago they open
'F:\3 Year Planning\15-10-2019\[Strategic cost forecast Assumptions.xlsb

The formula ignores the fact that the folder was different and the formula becomes
='[Strategic cost forecast Assumptions.xlsb]Constants'!O22
and updates the new file with old data?

We want to avoid building the date into the filename.

Can I stop it thinking that because the filename is the same it's a different file to the original link?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top