bsharath
asked on
Too many different cell formats. I get this error when i run any script and work on any thing in this excel.
Hi,.
Too many different cell formats. I get this error when i run any script and work on any thing in this excel.
How can i find which colum or cells has these many different formatting.
I changed all to similar font or format. But still get this issue.
Regards
Sharath
Too many different cell formats. I get this error when i run any script and work on any thing in this excel.
How can i find which colum or cells has these many different formatting.
I changed all to similar font or format. But still get this issue.
Regards
Sharath
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks but what all include in this format reset.
This will remove ALL formats from all cells in the active worksheet. If you do this on every worksheet in your workbook, I can pretty much guarantee that you'll only have __1__ format left. Your "too many different cell formats" message will go away.
Sharath,
The best tool that I have found for removing this problem from large spreadsheets (where manually removing the formatting in large chunks is not practical or desireable) is by a crowd called xlsgen, http://xlsgenreduction.arstdesign.com/index_en.html. While it does cost $50 it is a must have utility
Free tools - that from my experience don't achive the same quantity of reduction as xlsgen - but will still help include Leo Heuser's code at http://www.j-walk.com/ss/excel/eee/eee007.txt and ASAP utilities, http://www.asap-utilities.com/
Cheers
Dave
The best tool that I have found for removing this problem from large spreadsheets (where manually removing the formatting in large chunks is not practical or desireable) is by a crowd called xlsgen, http://xlsgenreduction.arstdesign.com/index_en.html. While it does cost $50 it is a must have utility
Free tools - that from my experience don't achive the same quantity of reduction as xlsgen - but will still help include Leo Heuser's code at http://www.j-walk.com/ss/excel/eee/eee007.txt and ASAP utilities, http://www.asap-utilities.com/
Cheers
Dave
ASKER
Dave i tried the first like. That is not free but when selected the xlsm file i get an error
The sceript can you tell me which code should i use?
ASAP is this free and will this work for the issue i have
The sceript can you tell me which code should i use?
ASAP is this free and will this work for the issue i have
ASKER
Dave i tried the first like. That is not free but when selected the xlsm file i get an error
The sceript can you tell me which code should i use?
ASAP is this free and will this work for the issue i have
The sceript can you tell me which code should i use?
ASAP is this free and will this work for the issue i have
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes i have this issue in Excel 2007
ASKER
Yes i have this issue in Excel 2007
ASKER