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?
Click to expand...

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.
 
Top