![]() |
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