nicolasalvidrez
New member
When trying to open Excel 2010 file "Excel cannot complete this task with available resources. Choose less data or close other applications."
Anyone else having this issue?
Anyone else having this issue?
Excel 2010 file
- Thread starter nicolasalvidrez
- Start date
MawarbinCik
New member
This error can occur if you have a very large spreadsheet (for example, over 10,000 rows). The following steps may resolve the issue:
1. Close all applications, including Excel, and re-open the spreadsheet. Also ensure that all other Excel spreadsheets which are not needed are closed.
2. Remove any (unneccessary) formatting in your Excel sheets:
o Select all (Ctrl + A)
o In the right-hand side of the "Home" ribbon, select "Clear" and then "Clear Formats".
3. Set automatic calculations to manual. By default, Excel (re-)calculates any formulas whenever a change is made. To improve Excel performance, you can set this to manual as follows: (i) Click on the Excel ribbon or on 'File' in the top-left corner (depending on your version of Excel), (ii) Select "Options", (iii) go to the "Formulas" ribbon, (iv) select "Manual" (under Calculation options), (v) select OK. To carry out any calcutions manually, go to the "Formulas" ribbon, and select "Calculate Now" (on the right-hand side of the toolbar).
4. Restart your computer if the above steps still did not resolve your issue.
5. Close any non-crucial background applications after restarting, such as Google Desktop Search, as follows:
o Press Ctrl + Shift + Esc to bring up the Task Manager (or Ctrl + Alt + Del and select the Task Manager)
o Click on the "Processes" tab
o Select the service or program you want to shutdown, but please note: do not shutdown any task where the username is "System" or if you are not sure what the application is. Shutting down any essential system processes can cause your computer to freeze.
o Click on End Task at the bottom of the Task Manager to end the application.
6. Permanenty disable background/startup applications:
o Press Windows Key + R.
o Type msconfig, and click 'OK'.
o In the "General" tab choose "Selective Startup".
o In the "Startup" tab, disable (uncheck) any items which are not required.
o In the "Services" tab, select "Hide All Microsoft Services", then disable (uncheck) any items which are not required.
o Select 'OK' and restart your computer.
7. Split your data into multiple spreadsheets.
1. Close all applications, including Excel, and re-open the spreadsheet. Also ensure that all other Excel spreadsheets which are not needed are closed.
2. Remove any (unneccessary) formatting in your Excel sheets:
o Select all (Ctrl + A)
o In the right-hand side of the "Home" ribbon, select "Clear" and then "Clear Formats".
3. Set automatic calculations to manual. By default, Excel (re-)calculates any formulas whenever a change is made. To improve Excel performance, you can set this to manual as follows: (i) Click on the Excel ribbon or on 'File' in the top-left corner (depending on your version of Excel), (ii) Select "Options", (iii) go to the "Formulas" ribbon, (iv) select "Manual" (under Calculation options), (v) select OK. To carry out any calcutions manually, go to the "Formulas" ribbon, and select "Calculate Now" (on the right-hand side of the toolbar).
4. Restart your computer if the above steps still did not resolve your issue.
5. Close any non-crucial background applications after restarting, such as Google Desktop Search, as follows:
o Press Ctrl + Shift + Esc to bring up the Task Manager (or Ctrl + Alt + Del and select the Task Manager)
o Click on the "Processes" tab
o Select the service or program you want to shutdown, but please note: do not shutdown any task where the username is "System" or if you are not sure what the application is. Shutting down any essential system processes can cause your computer to freeze.
o Click on End Task at the bottom of the Task Manager to end the application.
6. Permanenty disable background/startup applications:
o Press Windows Key + R.
o Type msconfig, and click 'OK'.
o In the "General" tab choose "Selective Startup".
o In the "Startup" tab, disable (uncheck) any items which are not required.
o In the "Services" tab, select "Hide All Microsoft Services", then disable (uncheck) any items which are not required.
o Select 'OK' and restart your computer.
7. Split your data into multiple spreadsheets.
Last edited by a moderator:
SpyderTracks
We love you Ukraine
There seem to be a lot of these kinds of threads with new members posting a problem (usually office related), then a brand new member posting a solution involving some dodgy third party tool. This is like the 4th one I've seen in the past couple of weeks, and you never see any further contributions by any of the members...
Is this a clever spamming thing?
Is this a clever spamming thing?
ihavenoideawhatiamdoing
Rising Star
Don't think so...
nicolasalvidrez
New member
I really have a problem with excel!
I think many of us have had problems with Excel
Did you try any of the suggestions? And if so did it help - though given your comment I'm guessing not.
Stephen M
Author Level
This is a long shot but worth trying if you can. Are you able to copy the file, if yes put it on a USB drive and, if you know someone with Linux see if it will open on that. It will not solve the problem but programmes like Libre Office and other Linux Office suites will open practically anything and it would at least give you the file to work with.
DaelpixPhotos
Super Star
I've noticed that too