lack of resources in Excel Solved

Question

Hello,after updating a very large data table, I wanted to delete 43 rows that have become unnecessary, Excel sends me a message saying "Excel cannot complete this task with the available resources; please select fewer data or close some applications"; however, I have nothing open except Excel - can you help me, thank you in advance

fifreline · Accepted Answer

Indeed, it would be nice to let us know if the proposed solutions have resolved your issue!
I remember something strange: a file sharing account with Google or Windows Live, it gets blocked as long as the files are not taken to be sent online...
Maybe there's a connection with this kind of thing?

Raymond PENTIER · Answer

Try to delete just one line first.
If that works, you can continue with 3, 4, or 6, gradually increasing the number of lines.
But you would certainly have other space-saving (memory) options to consider, such as the inserted images, the multicolored formatting; try to reduce the number of different fonts; check if you haven’t created any range names that are no longer used...
What is the size in kilobytes of your file?
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂

fifreline · Answer

either Excel is not capable, or your configurable choices are not optimally adjusted.
Excel, that's up to you...
you can choose the number of items you are allowed to delete, the capacity of the recycle bin, the amount of memory available for your calculations, the applications that start at the same time as Excel, and clean the free space on your hard drives and USB keys.
It should be noted that you are not allowed to delete a second thing before deleting the first thing:
for example, if I delete a formula on a table, all my calculations linked to that formula change to #.
if one of your empty rows is included in something else, it may simply come from that.

tamarii · Answer

ok thank you both, I will double check but this is the first time I've encountered this thing and I've been using Excel for a very long time, but it is also true that a mistake can slip in at any age lol, I'll keep you posted, if you don't mind, have a good Sunday
--
life is just a passage, let's try to leave only
good memories

tamarii · Answer

weight in kb 50475 .... a big -- life is just a passage, let's try to leave only good memories

fifreline · Answer

increase the working memory and the recycle bin memory simply.

Raymond PENTIER · Answer

Indeed, it's a substantial file!
Is there any possibility that you could make me an extract of less than 5 MB, even via private message if you wish to keep it confidential?
I would like to run some tests, particularly by giving names to certain long and complex references, as well as naming some formulas, to see if this provides a noticeable size gain. I could check if the existing formats and enhancements are truly likely to unnecessarily bloat your file.
It is clear that if your file contains both calculation tables, databases, macros, and series of charts, it can end up becoming unmanageable in terms of size/weight!
Best regards.
--
Retirement is great! Especially in the Antilles... :-)
☻ Raymond ♂

tamarii · Answer

Hello and thank you, that's exactly what was happening, pivot tables, charts, multiple formulas across several cells with many conditions, I found a solution that eliminates the problem, I split it into 4 separate files with links though, but it's manageable again and much faster to save - I admit I spent quite a bit of time on it and was a little scared it wouldn’t work but I succeeded and now I can go sleep a bit lolllllllllll
Thanks again for your help and have a good day
--
Life is just a passage, let's try to leave only
good memories

Lack of resources in Excel

8 réponses

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress

Inuyasha in french