Excel 2013: Resource heavy?

[blue-eye-boy]

I recently started using excel 2013 for business spreadsheets. At first it works fine, but recently it started acting different. When I start it, various spreadsheets, my laptop fan start blowing like mad, which I suppose it uses much of the resources available.

Then also, it feels sluggish, typing in cells, and when I press tab to go to the next tab, it's not responsive as it was. Then it also takes forever when I save the sheet, to upload to onedrive, many times I click cancel, just to be able to switch of the machine. Is there a way I can check the "size" of the file, not the mb, but more the amount of calculations and processes which run, as I think that will be the problem factor here.

I did google this, and he info I got, is to repair the install, which I did. I also checked the add-ons, which there was none.

The laptop is not a dinky toy, so a slow laptop is definitely not the problem, no other program battle to run like excel.

Thanks in advance.....

 

[envo]

I recently started using excel 2013 for business spreadsheets. At first it works fine, but recently it started acting different. When I start it, various spreadsheets, my laptop fan start blowing like mad, which I suppose it uses much of the resources available.

Then also, it feels sluggish, typing in cells, and when I press tab to go to the next tab, it's not responsive as it was. Then it also takes forever when I save the sheet, to upload to onedrive, many times I click cancel, just to be able to switch of the machine. Is there a way I can check the "size" of the file, not the mb, but more the amount of calculations and processes which run, as I think that will be the problem factor here.

I did google this, and he info I got, is to repair the install, which I did. I also checked the add-ons, which there was none.

The laptop is not a dinky toy, so a slow laptop is definitely not the problem, no other program battle to run like excel.

Thanks in advance.....

You might not think the size of your excel spreadsheet matters, but it does, a whole lot, and the one big thing that makes me think its the size of the spreadsheet is the fact it takes forever to upload to onedrive.

You can have the most powerful laptop in the world, if the size of the spreadsheet increases, so does the time it takes to load it up

 

[ElecEng]

is it the 32 or 64 bit version of excel? if it is the 32 bit, remove it and install the 64 bit. the 32bit version only has access to 2GB of Ram and can only execute calculations in 32bits. I had issues with crashing and extreme unresponsiveness with the 32 bit version (i was working with a year of one minute recordings from 500 devices and using semi-complex filters and formulas). the 64 bit version still took a while to calculate the spreadsheet but it didn't crash. Also try turning off the auto-calculate option. so you enter your formula's, save the work sheet, then make it calculate everything. this way it is not trying to recalculate the worksheet after every cell entry.

 

[blue-eye-boy]

is it the 32 or 64 bit version of excel? if it is the 32 bit, remove it and install the 64 bit. the 32bit version only has access to 2GB of Ram and can only execute calculations in 32bits. I had issues with crashing and extreme unresponsiveness with the 32 bit version (i was working with a year of one minute recordings from 500 devices and using semi-complex filters and formulas). the 64 bit version still took a while to calculate the spreadsheet but it didn't crash. Also try turning off the auto-calculate option. so you enter your formula's, save the work sheet, then make it calculate everything. this way it is not trying to recalculate the worksheet after every cell entry.

This seem like the problem yes, it calculates every entry every time. If I turn it off, but want the calculations to be done, is there a way to manually "tell" it to do calculations?

 

[blue-eye-boy]

is it the 32 or 64 bit version of excel? if it is the 32 bit, remove it and install the 64 bit. the 32bit version only has access to 2GB of Ram and can only execute calculations in 32bits. I had issues with crashing and extreme unresponsiveness with the 32 bit version (i was working with a year of one minute recordings from 500 devices and using semi-complex filters and formulas). the 64 bit version still took a while to calculate the spreadsheet but it didn't crash. Also try turning off the auto-calculate option. so you enter your formula's, save the work sheet, then make it calculate everything. this way it is not trying to recalculate the worksheet after every cell entry.

I checked, it is the 32 bit version. I didn't know there's a 64 bit version too, I just downloaded the office 365 package. I will check into this thanks.