PremSivakanthan
New Member
Hi all, I have been working on a dashboard that is continually being added to and refined. This report needs to be saved in a .xls format to ensure everybody in our company can open it without any problems. I have written some code to save it in a number of different formats, and that was working fine until last week. The code would execute and the file would save, but whenever anybody tried to open the file, excel would crash. After many hours of problem solving, I have tracked it down to the message that comes up when saving: Defined names of formulas in this workbook may display different values when they are recalculated...Do you want Excel to recalculate all formulas when this workbook is opened?". When I select yes, and try to open the file it crashes, but when I select no and try and open the file everything is fine.
Questions:
1) How do I control this via vba? Setting Application.Displayalerts = False does not solve the problem, as while the alert wont come up, it appears that the default selection when using this is yes.
2) What does excel mean by this message, the best explanation I have been able to find is in this link
http://office.microsoft.com/en-ca/excel-help/change-formula-recalculation-iteration-or-precision-HP010054149.aspx#BMlearn_about_calculating_workbooks_tha
I have spent many hours scouring the net with no avail…!
Questions:
1) How do I control this via vba? Setting Application.Displayalerts = False does not solve the problem, as while the alert wont come up, it appears that the default selection when using this is yes.
2) What does excel mean by this message, the best explanation I have been able to find is in this link
http://office.microsoft.com/en-ca/excel-help/change-formula-recalculation-iteration-or-precision-HP010054149.aspx#BMlearn_about_calculating_workbooks_tha
I have spent many hours scouring the net with no avail…!