Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dropdown boxes make file size too large
Hi. I'm using Excel 2007. I have a cell with a dropdown box that has the
values 1 thru 10. When I save the file (as an Excel 97-2003 compatible .xls file), it's 17kb which is normal. I want multiple dropdown boxes going down the same column, so that every time the user goes to the next row, another dropdown box will be displayed. I copied the cell with the dropdown box, selected the entire column, and pasted the dropdown box. This time when I save the document, it's over 2MB in file size. I've seen other spreadsheets with several columns of dropdown boxes spanning thousands of rows and they stay under 30kb. I don't know what they did differently to keep their file size small. Why is my file size so large and how do I fix this? Do I need to use a 'paste special' function? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dropdown boxes make file size too large
Maybe because thousands of rows are still less than 1 million rows.
Regards, Stefi €˛Terin€¯ ezt Ć*rta: Hi. I'm using Excel 2007. I have a cell with a dropdown box that has the values 1 thru 10. When I save the file (as an Excel 97-2003 compatible .xls file), it's 17kb which is normal. I want multiple dropdown boxes going down the same column, so that every time the user goes to the next row, another dropdown box will be displayed. I copied the cell with the dropdown box, selected the entire column, and pasted the dropdown box. This time when I save the document, it's over 2MB in file size. I've seen other spreadsheets with several columns of dropdown boxes spanning thousands of rows and they stay under 30kb. I don't know what they did differently to keep their file size small. Why is my file size so large and how do I fix this? Do I need to use a 'paste special' function? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dropdown boxes make file size too large
Terin wrote:
Hi. I'm using Excel 2007. I have a cell with a dropdown box that has the values 1 thru 10. When I save the file (as an Excel 97-2003 compatible .xls file), it's 17kb which is normal. I want multiple dropdown boxes going down the same column, so that every time the user goes to the next row, another dropdown box will be displayed. I copied the cell with the dropdown box, selected the entire column, and pasted the dropdown box. This time when I save the document, it's over 2MB in file size. I've seen other spreadsheets with several columns of dropdown boxes spanning thousands of rows and they stay under 30kb. I don't know what they did differently to keep their file size small. Why is my file size so large and how do I fix this? Do I need to use a 'paste special' function? Thanks. How many rows are YOU actually using? You've attached the drop-down box to one million rows. Just copy it to the rows that need it, not the entire column. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Large File Size | Excel Discussion (Misc queries) | |||
Excel File size too large | Excel Discussion (Misc queries) | |||
Excel file size too large | Excel Worksheet Functions | |||
Large File Size in 2003 | Excel Discussion (Misc queries) | |||
why is the size of my file so large? | Excel Discussion (Misc queries) |