I'm trying to reset missing cell styles for a tab.

I have a spreadsheet that somehow has lost almost all of the built-in cell style formats.  All I can see is 20% Accent, no others. 

 

Copying the tab to a new spreadsheet removes most cell styles (except 20% Accent) on the newly copied tab.  All other spreadsheet tabs are also affected.  I've also tried copying and pasting the cells to a new workbook, and that creates the same style problem on all tabs of the new workbook that I paste the cells into.

 

I'm using Excel 2007, but I've also tried the spreadsheet on 2010, and have the same problem.

 

Any ideas would be appreciated!  Thanks.

 

Answer
Answer

Hello

See if this article helps (based on Excel 2003 - Change path to 'office12', from 'office11' in article):

http://office.microsoft.com/en-us/excel-help/reset-workbook-and-worksheet-settings-HP005202207.aspx

Also, look at this thread:

http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/e59e9b8d-9cda-4385-9b06-712df76c9861

Hope they help.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated December 16, 2024 Views 3,710 Applies to: