Hi there, been searching everywhere did not find anything so not sure if it is possible.
I have a workbook that has on one of its sheets a matrix formula that is very resource hungry so every time that I type anything on Sheet1 excel hangs for 10s so it will update this matrix formula.
Sheet1 has many formulas (all of them referring to Sheet1) so I need to find a way to turn on calculation only to active sheet. I saw that it is possible to do that but I need to execute the macro every time or press Shift F9 that would update only the active worksheet.
I don’t know how to do it but I was thinking that if I could find a way that every time that I type something on any cell of Sheet1 make a VBA code that would press Shift F9. If there is any other, easier way please let me know.
I´ve had to set Workbook Calculation to Manual. Let me know if I can set it back to automatic, and prevent this matrix sheet of calculating automatically.
Thanks in advance.
Sururu
Bookmarks