Jump to content
botrel

Office question

Recommended Posts

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?

Share this post


Link to post
Share on other sites

Yep.

 

The way you fix it: Close the other application.

Then open your desk drawer and pull your pants down.

Take a dump in the drawer and leave it for the weekend.

 

Once you return on Monday, not being able to open Excel 2010 files will be the least of your problems.

Share this post


Link to post
Share on other sites

 

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?

 

 

Close whatever else you're using and try again, if not get more memory.

Share this post


Link to post
Share on other sites

LOL.

 

Still awaiting response to the last question we had. Since pointing out that we edit out all external links to posts like this we are getting less and less answers to these kinds of questions.

 

Odd that...

Share this post


Link to post
Share on other sites

Cheap Tech Support just ask Atomic Forums.

 

Maybe you should put a email verify system on first 10 posts to stop spamming.

Share this post


Link to post
Share on other sites

We do actually use some antispam systems on the board. But they are canny and seem to have come up with new tricks to get around it.

 

The trick is to make it not offputting to new users, but more difficult for spammers. It's a fine line.

Share this post


Link to post
Share on other sites

It's a fine line.

 

Between pleasure and pain.

You've done it once you can do it again

Whatever you've done don't try to explain

It's a fine, fine line between pleasure and pain.

:-)

 

  • Like 2

Share this post


Link to post
Share on other sites

This error can occur if you have a very large spreadsheet (for example, over 10,000 rows). The following steps may resolve the issue:

Close all applications, including Excel, and re-open the spreadsheet. Also ensure that all other Excel spreadsheets which are not needed are closed.

Remove any (unneccessary) formatting in your Excel sheets:

Select all (Ctrl + A)

In the right-hand side of the "Home" ribbon, select "Clear" and then "Clear Formats".

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).

Restart your computer if the above steps still did not resolve your issue.

Close any non-crucial background applications after restarting, such as Google Desktop Search, as follows:

Press Ctrl + Shift + Esc to bring up the Task Manager (or Ctrl + Alt + Del and select the Task Manager)

Click on the "Processes" tab

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.

Click on End Task at the bottom of the Task Manager to end the application.

Press Windows Key + R.

Type msconfig, and click 'OK'.

In the "General" tab choose "Selective Startup".

In the "Startup" tab, disable (uncheck) any items which are not required.

In the "Services" tab, select "Hide All Microsoft Services", then disable (uncheck) any items which are not required.

Select 'OK' and restart your computer.

Permanenty disable background/startup applications:

Split your data into multiple spreadsheets.

Read more info

Edited by Chaos.Lady
External link removed

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×