I'm trying to add columns and getting errors

K

Kimb

I am working on a very large spreadsheet, grouping columns. I am trying to
add additional columns and keep getting the error " Cannot Shift Objects off
sheet".
I don't want to delete any of the columns, but how do I get past this error
and what does it mean?
 
J

John C

xl2003 has a limit of 256 columns. It sounds as if you are trying to create
more columns by inserting a new column than excel can handle. Unfortunately,
you can't. You will either need to split the sheet into 2 worksheets, or get
xl2007, which has significantly more columns.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
VSTO C# add in Outlook.Appointment error 0
"The operation cannot be performed because the object has been deleted." 0
Dealing with a Pivot Table (when I don't want to) 0
Hiding Column Issue 1
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top