#1   Report Post  
Old January 11th 05, 01:09 AM
BW
 
Posts: n/a
Default File got huge

I took a file that was about 300k, opened it in Excel 2003. I copied and
pasted all the data onto a second page so that I could manipulate it without
changing the original data. I hid a couple of columns, sorted the data,
centered a couple of columns, did some global search/replace, gave the sheet
a header & set the margins, paper size and orientation. Then I saved the
file and it was 44MB.

I did nothing that should have created a file this big...no charts, no VBA,
nothing. What's up with this??

Thanks




  #2   Report Post  
Old January 11th 05, 01:15 AM
Norman Jones
 
Posts: n/a
Default

Hi BW,

See Debra Dalgleish's notes on resetting the used range / file size at:

http://www.contextures.com/xlfaqApp.html#Unused

---
Regards,
Norman



"BW" wrote in message
...
I took a file that was about 300k, opened it in Excel 2003. I copied and
pasted all the data onto a second page so that I could manipulate it
without changing the original data. I hid a couple of columns, sorted the
data, centered a couple of columns, did some global search/replace, gave
the sheet a header & set the margins, paper size and orientation. Then I
saved the file and it was 44MB.

I did nothing that should have created a file this big...no charts, no
VBA, nothing. What's up with this??

Thanks




  #3   Report Post  
Old January 11th 05, 01:57 AM
BW
 
Posts: n/a
Default

That did it. I've used Excel for years with huge files & never had this
problem.

Thanks

BW

"Norman Jones" wrote in message
...
Hi BW,

See Debra Dalgleish's notes on resetting the used range / file size at:

http://www.contextures.com/xlfaqApp.html#Unused

---
Regards,
Norman



"BW" wrote in message
...
I took a file that was about 300k, opened it in Excel 2003. I copied and
pasted all the data onto a second page so that I could manipulate it
without changing the original data. I hid a couple of columns, sorted the
data, centered a couple of columns, did some global search/replace, gave
the sheet a header & set the margins, paper size and orientation. Then I
saved the file and it was 44MB.

I did nothing that should have created a file this big...no charts, no
VBA, nothing. What's up with this??

Thanks









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
File asks to update when no links were created Dave Links and Linking in Excel 1 December 16th 04 08:10 PM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 04:45 PM
format question when open csv file Jeff Excel Discussion (Misc queries) 1 December 1st 04 06:53 PM
Convert text file to MS_Excel Aqua Flow Excel Discussion (Misc queries) 1 November 30th 04 02:55 AM


All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017