excel error

techp
techp used Ask the Experts™
on
attached error on excel 2010
excel-error.docx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Excel thinks your worksheet iss too large. I.E in Excel 2003 the maximum book size was

1-65536 rows, A - ZZ columns

try selecting all the columns that are unneeded, all the way to ZZ and deleting them

then try your insert operation again.

Author

Commented:
it is excel 2010
Darren SharplesSystems Specialist

Commented:
first, go select the entire column to the right of your last column of data, hold "shift" + "end" and press the right direction key.  This will select all blank rows to the right of your data, right click on one of the columns and hit delete.  Do the same for the row after your last peice of data but press the down direction key.  This should do it
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Author

Commented:
I am able to delete the row but cannot “ INSERT” the row again same error . only for one particular file
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
is the file .xls or .xlsx ?
if it's .xls, try to "save as .xlsx, and eventually reopen the file after that ....

Author

Commented:
if it is xlsx,then
Darren SharplesSystems Specialist

Commented:
Can I just confirm that you deleted all columns after your data until column 'XFD'

and all rows after your data until row number '1048576'?
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
you may want to upload your file?
Darren SharplesSystems Specialist

Commented:
or could you copy all of the cells that contain your data into a new excel workbook.  See if you can then insert your column.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial