A design table (example in training manual) was created using the Auto-create option.  In the training manual it instructs me to change cell \\\$STATE@Plank<1> to \\\$STATE@Plank<*>

However, when I try and modify or even hit enter without modifying the cell it give me the following error.

      SolidWorks Error:  The value you have entered is invalid.  Please enter a valid value before continuing.

The problem seems to come from cells with @.  I ensured that hyperlinks were removed from the cell but this did not fix anything.

As suggested by Kyle in SW forum I ran:

close SW
run: start->All Programs->Microsoft Office->Microsoft Office Tools->Microsoft Office Diagnostics

This also didn’t work.

Is this an Excel 2007 problem or SW problem or user error?

Is there a work around?

PS:  I found the new user interface for Excel 2007 very annoying and recommend people stay with Excel 2003 if possible.