CODEWITHSUNDEEP
excelvba
n4pster
n4pster

Reputation: 103

Excel with VBA, Workbook calculations on Manual, shift-F9 does not work

I have a large excel file with vba codes. When opening the file, excel automatically started calculating, hence it took minutes to even open the file. I set the workbook calculations in File/Options to Manual which solved the problem. However, when I run the macro now, it does not update the cells. Instead it puts the correct formulas in each cell without calculating to find the right value.

Strangely, Shift F9 does not work anymore. Yet when I go to one of the cells and press F2+ENTER the correct value is displayed.

Any idea how I can solve this issue?

Upvotes: 1

Views: 1681

Answers (1)

Andreas Covidiot
Andreas Covidiot

Reputation: 4745

creating or moving some/all reference containing worksheets (out and) into your workbook may solve it. More details here: https://stackoverflow.com/a/56549247/1915920

Upvotes: 0

Related Questions