Excel unable to refresh data. Macros may be disabled.

Excel - I get message "Unable to refresh data. Cannot run the macro "XFInternalPrepareCalculationStep". 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
ConernestoAsked:
Who is Participating?
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
1. Check Calculation is set to Automatic from the Formulas Tab -> Calculation Options

2. Is that macro in your workbook?

If the macro is failing then it might be switching Calculation to manual, but the error stops it from returning Calculation to automatic.
0
 
ConernestoAuthor Commented:
I use Excel 2013.
0
 
ConernestoAuthor Commented:
Thank you.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Roy CoxGroup Finance ManagerCommented:
Pleased to help. What was causing the problem?
1
 
ConernestoAuthor Commented:
I think it was a bug. I was opening Excel with VBA code in Access database.
0
 
Roy CoxGroup Finance ManagerCommented:
Thanks for letting me know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.