Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
Hello,
Is there a way to suppress or stop this message? I'm using Excel 2003 with XP. I am unwilling to break my spreadsheet apart to satisfy the 4,000 format limit. Any help? Thank you, ToOfWe. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
How about removing some of the formatting?
ToOfWe wrote: Hello, Is there a way to suppress or stop this message? I'm using Excel 2003 with XP. I am unwilling to break my spreadsheet apart to satisfy the 4,000 format limit. Any help? Thank you, ToOfWe. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
"Dave Peterson" wrote: How about removing some of the formatting? Dave Peterson Thank you fr responding. I've done that a few times but I doesn't seem to help for very long - maybe a few weeks. The spreadsheet is quite old and perhaps there are formats that I don't see. Is there a tool that can identify the different formats, then I can get rid of the ones I don't need, or want. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
I've never seen anything like that.
Maybe you could just reapply the formatting you want--to whole columns/rows. And try to stay away from using too many of them. Maybe even clearing the formats (watch out for Conditional formatting if you use that) would help. ToOfWe wrote: "Dave Peterson" wrote: How about removing some of the formatting? Dave Peterson Thank you fr responding. I've done that a few times but I doesn't seem to help for very long - maybe a few weeks. The spreadsheet is quite old and perhaps there are formats that I don't see. Is there a tool that can identify the different formats, then I can get rid of the ones I don't need, or want. Thanks. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
Every so often I delete existing tabs and then create blank ones and copy the
data back and manually format the cells with what already exists on other tabs. Like other fixes, this doesn't work for too long. I'll keep fighting with the spreadsheet. I'm pretty sure I'm not at 4,000 different formats, but even if I was perhaps Microsoft could just remove the 4,000 limit. Just a thought. Thanks for replying, ToOfWe "Dave Peterson" wrote: I've never seen anything like that. Maybe you could just reapply the formatting you want--to whole columns/rows. And try to stay away from using too many of them. Maybe even clearing the formats (watch out for Conditional formatting if you use that) would help. ToOfWe wrote: "Dave Peterson" wrote: How about removing some of the formatting? Dave Peterson Thank you fr responding. I've done that a few times but I doesn't seem to help for very long - maybe a few weeks. The spreadsheet is quite old and perhaps there are formats that I don't see. Is there a tool that can identify the different formats, then I can get rid of the ones I don't need, or want. Thanks. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
Dave,
I hope you don't mind me butting in here, but I believe formatting to whole columns/rows can increase the file size, as Excel may consider the last cells, (in this case the last formatted cell), as the last used cell, thereby creating further problems, such as slow to open/save, etc. Rob "Dave Peterson" wrote in message ... I've never seen anything like that. Maybe you could just reapply the formatting you want--to whole columns/rows. And try to stay away from using too many of them. Maybe even clearing the formats (watch out for Conditional formatting if you use that) would help. ToOfWe wrote: "Dave Peterson" wrote: How about removing some of the formatting? Dave Peterson Thank you fr responding. I've done that a few times but I doesn't seem to help for very long - maybe a few weeks. The spreadsheet is quite old and perhaps there are formats that I don't see. Is there a tool that can identify the different formats, then I can get rid of the ones I don't need, or want. Thanks. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
It may be the type of formatting that's applied.
If I start a new worksheet and apply a fill color to column F, then hit ctrl-end, I am taken to F1. If I start a new workbook and do nothing but save it, I see a file size of 13k. If I save that workbook (xl2003) with column F shaded, I see a filesize of about 13k. RobN wrote: Dave, I hope you don't mind me butting in here, but I believe formatting to whole columns/rows can increase the file size, as Excel may consider the last cells, (in this case the last formatted cell), as the last used cell, thereby creating further problems, such as slow to open/save, etc. Rob "Dave Peterson" wrote in message ... I've never seen anything like that. Maybe you could just reapply the formatting you want--to whole columns/rows. And try to stay away from using too many of them. Maybe even clearing the formats (watch out for Conditional formatting if you use that) would help. ToOfWe wrote: "Dave Peterson" wrote: How about removing some of the formatting? Dave Peterson Thank you fr responding. I've done that a few times but I doesn't seem to help for very long - maybe a few weeks. The spreadsheet is quite old and perhaps there are formats that I don't see. Is there a tool that can identify the different formats, then I can get rid of the ones I don't need, or want. Thanks. -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
Rob
Have you experimented with this theory? Open a new workbook. Save then check FileProperties for size. Format a great bunch of rows and columns. Save then check FileProperties for size. Gord Dibben MS Excel MVP On Sat, 21 Jun 2008 17:53:59 +0930, "RobN" wrote: Dave, I hope you don't mind me butting in here, but I believe formatting to whole columns/rows can increase the file size, as Excel may consider the last cells, (in this case the last formatted cell), as the last used cell, thereby creating further problems, such as slow to open/save, etc. Rob "Dave Peterson" wrote in message ... I've never seen anything like that. Maybe you could just reapply the formatting you want--to whole columns/rows. And try to stay away from using too many of them. Maybe even clearing the formats (watch out for Conditional formatting if you use that) would help. ToOfWe wrote: "Dave Peterson" wrote: How about removing some of the formatting? Dave Peterson Thank you fr responding. I've done that a few times but I doesn't seem to help for very long - maybe a few weeks. The spreadsheet is quite old and perhaps there are formats that I don't see. Is there a tool that can identify the different formats, then I can get rid of the ones I don't need, or want. Thanks. -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many different cell formats.
Gord & Dave,
Not experimented, but my input was based on what I've gleaned from other replies from learned Excel users as yourselves, as well as seeing it written on someone's website, albeit not one I can remember. I didn't think that simply doing what you've suggested would on its own increase the size, etc., but I'm not convinced that it doesn't have some part to play when files become troublesome. Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Rob Have you experimented with this theory? Open a new workbook. Save then check FileProperties for size. Format a great bunch of rows and columns. Save then check FileProperties for size. Gord Dibben MS Excel MVP On Sat, 21 Jun 2008 17:53:59 +0930, "RobN" wrote: Dave, I hope you don't mind me butting in here, but I believe formatting to whole columns/rows can increase the file size, as Excel may consider the last cells, (in this case the last formatted cell), as the last used cell, thereby creating further problems, such as slow to open/save, etc. Rob "Dave Peterson" wrote in message ... I've never seen anything like that. Maybe you could just reapply the formatting you want--to whole columns/rows. And try to stay away from using too many of them. Maybe even clearing the formats (watch out for Conditional formatting if you use that) would help. ToOfWe wrote: "Dave Peterson" wrote: How about removing some of the formatting? Dave Peterson Thank you fr responding. I've done that a few times but I doesn't seem to help for very long - maybe a few weeks. The spreadsheet is quite old and perhaps there are formats that I don't see. Is there a tool that can identify the different formats, then I can get rid of the ones I don't need, or want. Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
Too many different cell formats | Excel Discussion (Misc queries) | |||
Copy and link formats from cell to cell | Excel Discussion (Misc queries) | |||
too many different cell formats | Excel Discussion (Misc queries) | |||
Too Many Different Cell Formats | Excel Worksheet Functions |