I have created a spreadsheet with mulitple tabs each tab has vlookups back to a main data tab. I have added quite a few tabs with a lot of vlookups. All of the sudden Excel is really slowing down and in the bottom right corner it does calculating cells with a %. It does this everytime I do something on my spreadsheet. Takes about 30 seconds to do.
I have tried breaking my spreadsheet up into 2 different files and get the same results.
Any suggestions?
I have tried breaking my spreadsheet up into 2 different files and get the same results.
Any suggestions?