Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Experience with VERY large worksheets
I am just curious -- WHY are you using Excel instead of a database program?
Usually you can import a database program into Excel for various things where only certain parts of the database is being used at the time. Sorry -- just never knew anyone to use Excel for large things like you are doing -- usually persons use database programs (like Access). One nice thing about having Excel and Access in the office group is they interact with each other -- just like they do with word, etc. Judy M. "hce" wrote: Hi Are you using pivot tables...??? If you "inserted" new data in the "wrong" way, the file will grow crazy in size... I once had an experience where it grew from 6mb to 100mb...!!! but I was able to reduce it back to the normal size when I re-did how I inserted the new data... Another possible reason for the size is the unused range... Have you tried deleted the unused range...??? LAst possible reason could be that you are using non english fonts... such as korean characters... if yes, then the file would be bigger too... hope it helps... cheers -- hce ------------------------------------------------------------------------ hce's Profile: http://www.excelforum.com/member.php...fo&userid=3518 View this thread: http://www.excelforum.com/showthread...hreadid=266151 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
make large worksheet from workbook | Excel Discussion (Misc queries) | |||
Linked worksheets | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |