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.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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.
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
I am able to delete the row but cannot “ INSERT” the row again same error . only for one particular file
is the file .xls or .xlsx ?
if it's .xls, try to "save as .xlsx, and eventually reopen the file after that ....
if it's .xls, try to "save as .xlsx, and eventually reopen the file after that ....
Premium Content
You need an Expert Office subscription to comment.Start Free Trial