How to have the array formulas automatically updated (CTRL+ALT+F9)when the file gets open?

[sepehr485]

Hello all.
I have a file which has three tabs. each tab has a large table with bunch of Array formulas on it and usually what I do is I hit Ctrl+alt+F9 on each sheet to refresh the whole sheet. How can I have this done automatically when I open the file? I like to also get a alert that the report is updated once the refresh is done.


I have written some codes but it doesnt work properly.

Option Explicit
Sub auto_open()
Application.CalculateFull
End Sub


Thanks
Sep

[mohadin]

Hi
Make sure before saving the file

[sepehr485]

Thank you. Calculation is already set on automatic. the problem is formulas are complex and also combination of text and numbers. So I need to have a macro to do it automatically for all sheets once the file gets open.

Thanks

[mohadin]

Ah
I see
Your code should be

Please Login or Register  to view this content.

Land it in ThisWorkbook module