Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What makes a Large File in Excel?
I was working on a file for a friend and when I was finished, the file size
was about 1k. When she did the process, it was over 35k and even had one file over 128k. I was impressed by the size and I watched her do the process from scrach, it was 35k again. We are working on only one sheet of data to copy that is only about 1,800 lines and 46 columns. When I took her big file that broke and did past onto a new sheet, it was large again so I had to do past special values then format the columns like dates. any clue why some Excel Files are large? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What makes a Large File in Excel?
as an fyi - from the large file I deleted the blank lines after the date and
blank columns after the data and the file went from 31mb to 400k. It appears to have stuff in the blank columns? "Don" wrote: I was working on a file for a friend and when I was finished, the file size was about 1k. When she did the process, it was over 35k and even had one file over 128k. I was impressed by the size and I watched her do the process from scrach, it was 35k again. We are working on only one sheet of data to copy that is only about 1,800 lines and 46 columns. When I took her big file that broke and did past onto a new sheet, it was large again so I had to do past special values then format the columns like dates. any clue why some Excel Files are large? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What makes a Large File in Excel?
See Debra's site for info on large file sizes and how to reset.
http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Sat, 26 Apr 2008 07:53:00 -0700, Don wrote: I was working on a file for a friend and when I was finished, the file size was about 1k. When she did the process, it was over 35k and even had one file over 128k. I was impressed by the size and I watched her do the process from scrach, it was 35k again. We are working on only one sheet of data to copy that is only about 1,800 lines and 46 columns. When I took her big file that broke and did past onto a new sheet, it was large again so I had to do past special values then format the columns like dates. any clue why some Excel Files are large? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What makes a Large File in Excel?
thanks, this helped
"Gord Dibben" wrote: See Debra's site for info on large file sizes and how to reset. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Sat, 26 Apr 2008 07:53:00 -0700, Don wrote: I was working on a file for a friend and when I was finished, the file size was about 1k. When she did the process, it was over 35k and even had one file over 128k. I was impressed by the size and I watched her do the process from scrach, it was 35k again. We are working on only one sheet of data to copy that is only about 1,800 lines and 46 columns. When I took her big file that broke and did past onto a new sheet, it was large again so I had to do past special values then format the columns like dates. any clue why some Excel Files are large? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace All makes me look for a file! | Excel Discussion (Misc queries) | |||
excel file when opened makes 30 copies | Excel Discussion (Misc queries) | |||
Opening a CSV file makes MSI want Office 2000 SR-1 Premium disk (DATA1.MSI) | Excel Discussion (Misc queries) | |||
Opening a CSV file makes MSI want Office 2000 SR-1 Premium disk (DATA1.MSI) | Setting up and Configuration of Excel | |||
Large excel file | Excel Discussion (Misc queries) |