Hi Everyone!
New to the forum so thanks in advance for your time (^_^)
So here's my issue, I have a file linking to other workbooks.
Most update just fine but a couple of them won't update without me opening the source. Any idea to why this is?
FYI:
I do have access to all of the files,
1 of the 2 are password protected via the [General Options]. I do have other worksheets pulling from the password protected one and updates the values just fine.
Most of the files are tables.
I can't attach pictures/files yet but the error I'm getting is "Warning: Open source to update values" via [edit links]
2 says this error, others say "OK"
and when I try to enter the formula it thinks its a link so I can't post it right now... :-(
Bookmarks