Conernesto
asked on
Excel unable to refresh data. Macros may be disabled.
Excel - I get message "Unable to refresh data. Cannot run the macro "XFInternalPrepareCalculat ionStep". The macro may not be available in this workbook or all macros may be disabled". I get this message when I open a saved Excel workbook. Attached is a copy of the message. When I open the file formulas don't update.
Capture.PNG
Capture.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
Pleased to help. What was causing the problem?
ASKER
I think it was a bug. I was opening Excel with VBA code in Access database.
Thanks for letting me know.
ASKER