error come up "to prevent possible loss of data micosoft excel cannot shift
nonblank cells off the worksheet" What does this mean and how can I correct
it.
Even if you can't see it, Excel has more data than you think and trying to
insert columns or rows when Excel thinks it may move it outside 65536 rows
or 256 columns limit and therefore be lost is triggering this.
I have also found this to happen when you have cells formatted, even if you
have no data otherwise in those cells in the last so many rows/columns that
you are attempting to insert.
--
Sincerely,
Ronald R. Dodge, Jr.
Master MOUS 2000
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.
