Excel出現(xiàn)“不同的單元格格式太多”解決方案

原因：一個工作表常時間的使用，或經(jīng)多人不同的編輯會使表格的格式日積月累越來越多，以至在2003以下的版的用戶打不開（或格式超過4000種）大家可以去看看自己表格是否有過多的格式（色彩也是格式的一種）可以在單元格樣式中看到。如何來清除過多的格式呢解決方案：打開出現(xiàn)“太多不同的儲存格格式”的Excel文件；第一步：“開發(fā)工具”一“進入VB（VisualBasic）”（如下圖）第二步：打開代碼窗口，建模塊，在代碼窗口里將‘SubRebuildDefaultStyles'（見附檔）檔案中的內(nèi)容copy進去，替換原來的內(nèi)容第三步：運行代碼（點擊運行里選擇“運行子過程/用戶窗體”或直接點擊如圖箭頭所示）（如圖）第四步：看看工作表的格式是不是已去除了，如下圖那些在使用過程中留下的格式已除去了，只剩下Excel默認自帶的格式。你的工作表如果格式太多了，最好清一清，工作時盡量不要更換太多不一樣的格式。使用上述的辦法不會對你的工作表內(nèi)容更改。記得使用過后把代碼刪了。（文件占有空間也會變?。└綑n：SubRebuildDefaultStyles()'Thepurposeofthismacroistoremoveallstylesintheactive'workbookandrebuildthedefaultstyles.'Itrebuildsthedefaultstylesbymergingthemfromanewworkbook.'Dimensionvariables.DimMyBookAsWorkbookDimtempBookAsWorkbookDimCurStyleAsStyle'SetMyBooktotheactiveworkbook.SetMyBook=ActiveWorkbookOnErrorResumeNext'Deleteallthestylesintheworkbook.ForEachCurStyleIn'If<>"Normal"ThenSelectCaseCase"20%-Accent1","20%-Accent2","20%-Accent3","40%-Accent1","40%-Accent5","60%-Accent3","20%-Accent4","40%-Accent2","40%-Accent6","60%-Accent4","20%-Accent5","40%-Accent3","60%-Accent1","60%-Accent5","20%-Accent6","40%-Accent4","60%-Accent2","60%-Accent6","Accent1","Accent2","Accent3","Accent4","Accent5","Accent6","Bad","Calculation","CheckCell","Comma","Comma[0]","Currency","Currency[0]","ExplanatoryText","Good","Heading1","Heading2","Accent1","Accent2","Heading3","Heading4","Input","LinkedCell","Neutral","Normal","Note","Output","Percent","Title","Total","WarningText"'Donothing,thesearethedefaultstylesCaseElseEndSelectNextCurStyle'Openanewworkbook.SettempBook='DisablealertssoyoumaymergechangestotheNormalstyle'fromthenewworkbook.=False'Mergestylesfromthenewworkbookint