thisisrahul
Active Member
- Joined
- Sep 2, 2008
- Messages
- 286
Hi,
recently my Excel turns very slow, I understand that my excel usage is quite high but I still feel that it can be improved (yet to find out a optimal solution).
few additional information for anyone who can help
* I have to keep 4-5 workbooks open at the same time (all for monitoring purpose).
* I am using Bloomberg add in for live prices (multiple sheets referring to one sheet that extract live price from Bloomberg terminal).
* I am using some Conditional formatting to highlight any important change.
* My excel crashes 5-6 times every week.
I tried multiple solution available like Name manager, removing VLOOKUP and using XLOOKUP/Index(Match. But pain still persist.
Any help is welcome.
recently my Excel turns very slow, I understand that my excel usage is quite high but I still feel that it can be improved (yet to find out a optimal solution).
few additional information for anyone who can help
* I have to keep 4-5 workbooks open at the same time (all for monitoring purpose).
* I am using Bloomberg add in for live prices (multiple sheets referring to one sheet that extract live price from Bloomberg terminal).
* I am using some Conditional formatting to highlight any important change.
* My excel crashes 5-6 times every week.
I tried multiple solution available like Name manager, removing VLOOKUP and using XLOOKUP/Index(Match. But pain still persist.
Any help is welcome.