Quote Originally Posted by Jonmo1 View Post
This
CELL("filename")
Is a Volatile function, it recalculates every time anything is changed in the book.
Any time anything changes on any sheet, then Cell("filename") is recalcuated (on ALL sheets)
But it returns the sheet of whichever sheet is currently active to ALL occurances of the Cell("filename") function.


By changing it to
CELL("filename",A1)

That "Ties" the Cell function to a cell on that sheet.
So each one on each sheet is dependant on the A1 in it's own sheet.
Thanks so much for this one! I was having the exact problem described (i.e. all sheets used the same value) - this solved my problem for me!