problem with data table

P

pga05

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

accidently erased a cell in a data table (not pivot table) and now i can literally do nothing. I can't even quit excel, it just gives me a message reading "cant change part of a data table" what can i do?
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

accidently erased a cell in a data table (not pivot table) and now i can
literally do nothing. I can't even quit excel, it just gives me a message
reading "cant change part of a data table" what can i do?

If you have an error message that says "can't change part of a table",
then clicking OK should restore the previous value(s).

If you really can't do anything with XL, Force quit. If you have
AutoRecover enabled, starting XL again should bring up the last saved
version and Autorecover changes.
 

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

Top