Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation
Does anyone know if data validation uses a lot of space. I have a file which
was about 2MB and now that I have put in a lot of data validation selections it is now up to 8MB. The idea was to us DV to make the file safer for input reasons but now it is so big it is a little unstable which sort of defeats the purpose. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation
Not sure if DV is your problem but you may be better of using a usefrom for
user input. see workbooks section at: http://au.geocities.com/excelmarksway "Ant" wrote: Does anyone know if data validation uses a lot of space. I have a file which was about 2MB and now that I have put in a lot of data validation selections it is now up to 8MB. The idea was to us DV to make the file safer for input reasons but now it is so big it is a little unstable which sort of defeats the purpose. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |