ajay_gajree
Well-known Member
- Joined
- Jul 16, 2011
- Messages
- 518
Hi,
I have a large spreadsheet, which was initially of size 55KB plus, I have converted it to an xlsb format which has drastically reduced its size to under 3kb.
Regardless of this the spreadsheet is extremely unresponsive, probably due to the large number of calculations in it,
Can anyone give some tips on improving speed?
I have many vlookups for example, and they tend to have $A:$A references for example in them, would reducing the range make a difference?
Any general tips would be helpful!
I have a large spreadsheet, which was initially of size 55KB plus, I have converted it to an xlsb format which has drastically reduced its size to under 3kb.
Regardless of this the spreadsheet is extremely unresponsive, probably due to the large number of calculations in it,
Can anyone give some tips on improving speed?
I have many vlookups for example, and they tend to have $A:$A references for example in them, would reducing the range make a difference?
Any general tips would be helpful!