Microsoft Excel

[GinessaMancia]

Hello!
I get this error: Excel cannot perform this task with the resources available. Please choose less data or close other applications."
Can anyone suggest a solution?

[Fassou]

Check out this and this

Cheers!

[TRincon]

This error may occur if it is a large spreadsheet (for example, more than 10,000 rows). The following steps may resolve the issue:

1. Close all applications, including Excel, and reopen the spreadsheet. Also make sure that all other Excel spreadsheets that are not necessary are closed.

2. Remove any (unnecessary) formatting from the Excel sheet files: either select all (Ctrl + A) or on the right side of the "Home" ribbon, select "Clear" and then "Clear Formats".

3. Set automatic calculation to manual. By default, Excel (re-)calculates formulas whenever a change occurs. To improve performance, Excel can be switched to manual as follows: (i) Click on the Excel ribbon or on "File" in the upper left corner (depending on the Excel version), (ii) Select "Options", (iii) go to the "Formulas" ribbon, (iv) select "Manual" (under calculation options), (v) select OK. To perform any calcutions manually, go to the "Formulas" ribbon and select "Calculate" (on the right side of the toolbar).

4. Restart the computer if the above steps do not resolve the issue.

5. Close any non-essential background applications after restarting, such as Google Desktop Search, as follows: either press Ctrl + Shift + Esc to open Task Manager (or Ctrl Alt Del and select Task Manager) or click on the "Processes" tab or select the service or program you want to shut down, but please note: do not shut down any task where the user is "System" or if you are unsure about the application. Shutting down any essential system processes may cause crashes on the computer. or click on End Task at the bottom of Task Manager to terminate the application.

6. Permanenty disable background/startup applications: either press the Windows key R. or type msconfig and then click 'OK'. or on the "General" tab select "Selective Startup" or on the "Startup" tab, disable all items that are not necessary. or on the "Services" tab, select "Hide all Microsoft services", then disable all items that are not necessary. or select "OK" and restart the computer.

7. Split the data into several spreadsheets.

[CornelioMerlo]

¡Esta publicación está eliminada!