Cell Validation Bloating Workbook in 2007?

[Mr. Walnuts]

In the past, I've usually used Cell Validation to help reduce the size of a workbook.

The references say that by limiting the possible values for a cell, you reduce the amount of information required to use it. Is this not true? I have very specific values in a workbook I'm using; IE: most cells in a database on the workbook (well over 2,000 rows; 12 columns) conatin numeric whole numbers between 1 and 400,000. Another set of cells (roughly 20,000 cells) contain text strings of between 5 and 30 characters. By using validation to limit these ranges to only values used in them, am I bloating the workbook with too many limitation parameters?

 

[Yard]

I'm no expert but I'll give you my 2c!

I can't believe for a second that Data Validation reduces file size. It must increase it, since rather than just holding the value of 400,000, each cell must also hold the Data Validation rules.

Maybe there's some black magic in there somewhere - can't wait to find out!

edit: then again, if the Validation determines the data type (like Long, Double etc.), then maybe it does reduce the bits set aside for storing values. Just seems odd that the saving isn't outweighed by the storage of the rules themselves? Probably shouldn't have waded in quite so soon on this one....refer back to my first 3 words :ahem:

 

[Mr. Walnuts]

I view it the same way you do apparently.

I'm trying to figure it out