I have a number of editable workbooks which feed into a protected workbook.
When the users update the editable spreadsheets, they click save and move to
the next one, update, save etc etc. Then when I go into the protected
workbook it asks me if I want to update, which I choose to do, but for some
reason, the data previewed with that message then changes back to data which
isn't the most recent data and I have to go in to update and save all the
other workbooks again before my protected workbook shows the most recent
data. Is that how it's supposed to work?
Thanks in advance for any suggestions!
MissV

Try checking if your Calculation mode is turn to Manual, press F9 key
if the data does get updated,
Access via Tool on the menu bar Option Select Calculation
if it is checked Manual in the Calculation, check the Automatic


--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis










"MissV" wrote:

I have a number of editable workbooks which feed into a protected workbook.
When the users update the editable spreadsheets, they click save and move to
the next one, update, save etc etc. Then when I go into the protected
workbook it asks me if I want to update, which I choose to do, but for some
reason, the data previewed with that message then changes back to data which
isn't the most recent data and I have to go in to update and save all the
other workbooks again before my protected workbook shows the most recent
data. Is that how it's supposed to work?
Thanks in advance for any suggestions!
MissV

Hello, thanks for your reply. All the workbooks are showing as Automatic.
Could there be anything else causing this to happen?
MissV

"xlmate" wrote:

Try checking if your Calculation mode is turn to Manual, press F9 key
if the data does get updated,
Access via Tool on the menu bar Option Select Calculation
if it is checked Manual in the Calculation, check the Automatic


--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis










"MissV" wrote:

I have a number of editable workbooks which feed into a protected workbook.
When the users update the editable spreadsheets, they click save and move to
the next one, update, save etc etc. Then when I go into the protected
workbook it asks me if I want to update, which I choose to do, but for some
reason, the data previewed with that message then changes back to data which
isn't the most recent data and I have to go in to update and save all the
other workbooks again before my protected workbook shows the most recent
data. Is that how it's supposed to work?
Thanks in advance for any suggestions!
MissV