Unable to delete a column
Solved
r4944
Posted messages
136
Status
Member
-
Anonymous user -
Anonymous user -
Hello,
I've been stuck on this for 3 hours, I can't delete a column (N) and I keep getting the same error message (There isn't enough memory to complete this try using less data or .........) I also created a macro but it gives the same result, I've consulted several forums but no results :/
the file size is just 7Mb
Configuration: Windows 7 / Chrome 44.0.2403.130
I've been stuck on this for 3 hours, I can't delete a column (N) and I keep getting the same error message (There isn't enough memory to complete this try using less data or .........) I also created a macro but it gives the same result, I've consulted several forums but no results :/
the file size is just 7Mb
Configuration: Windows 7 / Chrome 44.0.2403.130
2 answers
-
Hello r4944,
First, the size of the file at 7 Mb is not the issue,
since it's a memory (RAM) problem:
“There isn't enough memory to complete this try...”.
Next, I find your problem really quite strange!
If you were trying to add a column of data, I could
understand that if you were already close to the high limit of RAM,
this operation could cause an overflow:
“not enough memory.”
But you want to remove a column of data!
So since there is currently enough RAM space to hold the data, there is no reason
for a data deletion operation to cause a RAM overflow (since it’s decreasing, not increasing)!
Finally, the only reason I know that would prevent the deletion
of a column (of data or empty) is simply that
your worksheet is protected and/or your workbook is protected.
So if you unprotect the worksheet and/or the workbook, your column deletion operation should work!
If that's not it, there's no need to ask me: I have no other ideas!
But if my various tips helped you solve your problem,
please remember to mark the topic as “Resolved.”
Best regards. 😊
-
Hello albkan
“There is no reason for a data deletion operation to cause a RAM overflow (since it's negative and not positive)!” That’s wrong, there are several reasons why this could happen!!!
But without any information about the file, it's hard to know which one.
Patrice
PS: “First of all, the file size of 7 Mb is not the issue, since it's a memory (RAM) problem” That’s also wrong: when opening the file, it is loaded into RAM!- Hello Patrice33740,
For the first point: Even if it's less?
I still see no reason for it; but okay,
I’m willing to believe you, if you say so...
For the second point: Of course, when opening the file,
its content is loaded into memory and can cause
a memory overflow (RAM) if there isn't enough! But according to the problem statement, before
the attempt to delete the column, the data has already been loaded into memory!
Otherwise, r4944 would have indicated that the problem occurs
when opening the file and not when attempting to
delete the column!
Best regards. 😊
-
It's far from being that simple!!!
In RAM, the space occupied by the file and the application constantly changes, especially with each calculation!
-
-
Hello,
“If I had an hour to solve a problem and my life depended on it, I would spend the first 55 minutes determining the right question to ask, for once I have it, I could solve the problem in less than five minutes.”
ALBERT EINSTEIN
--
Patrice
