ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2007 Update links does not send message when workbook not calculat (https://www.excelbanter.com/excel-discussion-misc-queries/146671-2007-update-links-does-not-send-message-when-workbook-not-calculat.html)

amcnelis

2007 Update links does not send message when workbook not calculat
 
Excel 2007 for files saved as .xlsm (macro) will not issue the message "links
to ##### were not updated because ##### was not recalculated before it was
saved" Is this working as designed? Documentation seems to indicate that
message should still be received, but it doesn't identify specific file
types. Is there a set up change required to activate this message?
Steps to create
Create a Detail workbook.xlsm and a Summary workbook.xlsm. Link data in the
Summary to the Detail. Turn on manual calc & no calc on save in both files.
Calc and save files. Open Detail workbook and make a change to a number, save
without calcing workbook. Open summary (while detail is closed) click on
security message, click option to enable links...the "not updated
because...not recalculated" message is not received. Also click on Edit
Links, click to update values, link displays as Ok, instead of displaying
error message.
Thanks in advance for assistance or advice.


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com