Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2002: Unable to delete Normal_xyz style inherited from workbook(xy
I am using EXCEL 2002.
a) When copying a sheet from workbook(A) to workbook(B), sometimes style Normal_A appears in workbook(B). This "sometimes" seems to be connected to new or changed styles in workbook(A). Is there a way to prevent the style Normal_A to appear. b) Sometimes it is possible and sometimes it is *not* possible to delete this style Normal_A in workbook(B). I have nor found an explanation for this. Is there a way to delete the style Normal_A, if Format / Style / Delete does not work? The problem is minor, but annoying (after many transfers of sheets). Martti Pekkanen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2002: Unable to delete Normal_xyz style inherited from workbook(xy
a) When copying a sheet from workbook(A) to workbook(B), sometimes style Normal_A appears in workbook(B). This "sometimes" seems to be connected to new or changed styles in workbook(A). It seems that *always* when the styles "Normal" are different in the two workbooks, this happens. But not otherwise. b) Sometimes it is possible and sometimes it is *not* possible to delete this style Normal_A in workbook(B). It seems that when the style Normal_A equals the EXCEL default style "Normal", the style Normal_A can be deleted. But not otherwise. I hope this is correct and helps someone. Thanks to Dave Peterson, who on the 10/6/2005 in Is it possible to change the default number format in Excel? gave an invaluable hint for the solution. Martti Pekkanen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Unable to open files in MS Outlook 2002 | Excel Discussion (Misc queries) | |||
Bug! Error Bars Inherited from Another Workbook - Any Fix? | Charts and Charting in Excel | |||
Can not delete Excel Style | Excel Discussion (Misc queries) | |||
Calendar Style Report in Access 2002 | Excel Discussion (Misc queries) | |||
"Unable to read file." Excel 2002 | Setting up and Configuration of Excel |