Hi

I have an excel file with macros and one form. The worksheet has 70
rows and 7 columns of data. Its size is 2.14 MB!!!

However if I copy-paste all the values, the form and the module t
another workbook, the new workbook's size is 100 KB...

Any explanations?

Thank you

--
pmguerr
-----------------------------------------------------------------------
pmguerra's Profile: http://www.excelforum.com/member.php...fo&userid=1498
View this thread: http://www.excelforum.com/showthread.php?threadid=53448

You may have many more cells formatted. See

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


--
Kind regards,

Niek Otten


"pmguerra" wrote in message
...
|
| Hi
|
| I have an excel file with macros and one form. The worksheet has 700
| rows and 7 columns of data. Its size is 2.14 MB!!!
|
| However if I copy-paste all the values, the form and the module to
| another workbook, the new workbook's size is 100 KB...
|
| Any explanations?
|
| Thank you!
|
|
| --
| pmguerra
| ------------------------------------------------------------------------
| pmguerra's Profile: http://www.excelforum.com/member.php...o&userid=14986
| View this thread: http://www.excelforum.com/showthread...hreadid=534485
|

You might want to look at this free Excel add-in utility which can clean
Excel projects:

http://www.appspro.com/Utilities/CodeCleaner.htm

Regards,
Edwin Tam

http://www.vonixx.com


"pmguerra" wrote:


Hi

I have an excel file with macros and one form. The worksheet has 700
rows and 7 columns of data. Its size is 2.14 MB!!!

However if I copy-paste all the values, the form and the module to
another workbook, the new workbook's size is 100 KB...

Any explanations?

Thank you!


--
pmguerra
------------------------------------------------------------------------
pmguerra's Profile: http://www.excelforum.com/member.php...o&userid=14986
View this thread: http://www.excelforum.com/showthread...hreadid=534485

Usually it is leftover "Used Range" space where old data was cleared from
the cells but not deleted. Excel remembers where things used to be so you
can use the "Undo" feature. However, it is not very good at cleaning up
after itself. To check for this, hit Ctrl+End. That will move the cursor to
the bottom right corner of the sheet's "Used Range". In your case it should
be G700. I suspect it will end up way down from there. You will want to
DELETE the entire rows and columns that are between your data and the ends
of the Used Range. once deleted, Save the workbook. If that doesn't help,
post back.

Mike F
"pmguerra" wrote in
message ...

Hi

I have an excel file with macros and one form. The worksheet has 700
rows and 7 columns of data. Its size is 2.14 MB!!!

However if I copy-paste all the values, the form and the module to
another workbook, the new workbook's size is 100 KB...

Any explanations?

Thank you!


--
pmguerra
------------------------------------------------------------------------
pmguerra's Profile:
http://www.excelforum.com/member.php...o&userid=14986
View this thread: http://www.excelforum.com/showthread...hreadid=534485

Thank you! It worked fine!!!

The problem is that I'm copy-pasting data from a Wordpad document. S
it also pastes about 10 columns to the right of "my range"...

Thanks again

--
pmguerr
-----------------------------------------------------------------------
pmguerra's Profile: http://www.excelforum.com/member.php...fo&userid=1498
View this thread: http://www.excelforum.com/showthread.php?threadid=53448