Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Error in updation of macro enabled workbook

0

Hello

I have a macro enabled excel file in which are certain formulas. The result of these formulas doesn't reflect automatically unless I save the file.

What can be the reason and what's the solution ?

Thanks

Viral

Answer
Discuss

Answers

0
Selected Answer

Hi there!

Sounds like you might have formula calculation set to manual. Go to the Formulas tab and look to the right and click Calculation Options and make sure there is a check next to "Automatic".

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login