Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reducing size of a file with no data
I have an excel file with several Sheets that was causing me troubles when
emailing it because it was too big. I separated each an every Sheet of it into different files to identifiy the biggest one. So i did, and after getting rid of colors, fancy fonts, lines, etc., the size was about the same. So, i started deleting the data of that sheet to find out what was the main problem. But i found out that even when i deleted the whole information and there was nothing on the screen the archive was still a ONE Megabyte file. What causes this? What does the file has that i cant see anything on the screen but there is still a lot of data recorded? |
#2
|
|||
|
|||
If you hit ctrl-end (on each worksheet), do you go way past where you know the
data ends? If yes... Visit Debra Dalgleish's site for some techniques for resetting that lastusedcell. http://www.contextures.com/xlfaqApp.html#Unused And if you have pictures/objects/comments embedded on those worksheets, they could be causing trouble. Oglu wrote: I have an excel file with several Sheets that was causing me troubles when emailing it because it was too big. I separated each an every Sheet of it into different files to identifiy the biggest one. So i did, and after getting rid of colors, fancy fonts, lines, etc., the size was about the same. So, i started deleting the data of that sheet to find out what was the main problem. But i found out that even when i deleted the whole information and there was nothing on the screen the archive was still a ONE Megabyte file. What causes this? What does the file has that i cant see anything on the screen but there is still a lot of data recorded? -- Dave Peterson |
#3
|
|||
|
|||
Thanks for the link but I tried again deleting all the arrows and columns
after page one and nothing happened. If i were to print what's on the screen, only ONE BLANK sheet of paper will come out of the printer. I really mean that there is NOTHING on the screen (no pictures, no objets, no comments, no visble data) to print. And page one is the only one active and the only one that would be printed (blank) if i wanted to do so. Still, the file is a 1MB file. If there's a chance to upload the file somewhere (or send it) so i can make myself clear please tell me so. "Dave Peterson" wrote: If you hit ctrl-end (on each worksheet), do you go way past where you know the data ends? If yes... Visit Debra Dalgleish's site for some techniques for resetting that lastusedcell. http://www.contextures.com/xlfaqApp.html#Unused And if you have pictures/objects/comments embedded on those worksheets, they could be causing trouble. Oglu wrote: I have an excel file with several Sheets that was causing me troubles when emailing it because it was too big. I separated each an every Sheet of it into different files to identifiy the biggest one. So i did, and after getting rid of colors, fancy fonts, lines, etc., the size was about the same. So, i started deleting the data of that sheet to find out what was the main problem. But i found out that even when i deleted the whole information and there was nothing on the screen the archive was still a ONE Megabyte file. What causes this? What does the file has that i cant see anything on the screen but there is still a lot of data recorded? -- Dave Peterson |
#4
|
|||
|
|||
I think You must have hidden objects. Try this: F5/Special.../Objects/OK
than press Delete ... -- pozdrav!/regards! Berislav Oglu wrote: Thanks for the link but I tried again deleting all the arrows and columns after page one and nothing happened. If i were to print what's on the screen, only ONE BLANK sheet of paper will come out of the printer. I really mean that there is NOTHING on the screen (no pictures, no objets, no comments, no visble data) to print. And page one is the only one active and the only one that would be printed (blank) if i wanted to do so. Still, the file is a 1MB file. If there's a chance to upload the file somewhere (or send it) so i can make myself clear please tell me so. "Dave Peterson" wrote: If you hit ctrl-end (on each worksheet), do you go way past where you know the data ends? If yes... Visit Debra Dalgleish's site for some techniques for resetting that lastusedcell. http://www.contextures.com/xlfaqApp.html#Unused And if you have pictures/objects/comments embedded on those worksheets, they could be causing trouble. Oglu wrote: I have an excel file with several Sheets that was causing me troubles when emailing it because it was too big. I separated each an every Sheet of it into different files to identifiy the biggest one. So i did, and after getting rid of colors, fancy fonts, lines, etc., the size was about the same. So, i started deleting the data of that sheet to find out what was the main problem. But i found out that even when i deleted the whole information and there was nothing on the screen the archive was still a ONE Megabyte file. What causes this? What does the file has that i cant see anything on the screen but there is still a lot of data recorded? -- Dave Peterson |
#5
|
|||
|
|||
Good morning Oglu Any macros? Multiple macro editing can cause exessive file size. Alternatively try this. File Save As... Select Web Page as the file type, then Entire Workbook and click OK. Close Excel. Reopen Excel and open the file from the HTML format. Now save the file back as .xls format. Does that decrease the size for you? Don't forget to delete the HTML files - they're no longer needed. HTH **** I've never had a problem using this trick, but only do it on a file you have a recent back up of **** DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=396739 |
#6
|
|||
|
|||
Good day
Thanks alot to all of you, i guess the problem was with macros. I saved it as an .html file and then export it to excel and it worked! Now the file is a 60 kb file instead of 1Mb. thanks for taking the time to solving others people's troubles. "dominicb" wrote: Good morning Oglu Any macros? Multiple macro editing can cause exessive file size. Alternatively try this. File Save As... Select Web Page as the file type, then Entire Workbook and click OK. Close Excel. Reopen Excel and open the file from the HTML format. Now save the file back as .xls format. Does that decrease the size for you? Don't forget to delete the HTML files - they're no longer needed. HTH **** I've never had a problem using this trick, but only do it on a file you have a recent back up of **** DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=396739 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reducing size of a file with no data
I have a same problem too, however, I delete the macro, name, and also save
as html and then back to .xls again. The file size only reduce 20K. Right now the file size is 150K. I know that a new file only have around 15-20K. Regards Jimmy "Oglu" wrote: Good day Thanks alot to all of you, i guess the problem was with macros. I saved it as an .html file and then export it to excel and it worked! Now the file is a 60 kb file instead of 1Mb. thanks for taking the time to solving others people's troubles. "dominicb" wrote: Good morning Oglu Any macros? Multiple macro editing can cause exessive file size. Alternatively try this. File Save As... Select Web Page as the file type, then Entire Workbook and click OK. Close Excel. Reopen Excel and open the file from the HTML format. Now save the file back as .xls format. Does that decrease the size for you? Don't forget to delete the HTML files - they're no longer needed. HTH **** I've never had a problem using this trick, but only do it on a file you have a recent back up of **** DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=396739 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reducing size of a file with no data
I am experiencing the same issue. I converted the file to html and the size
was reduced. However, when converting back to .xls, the size reverted to what it was before. Is it possible to leave it as .htm? Will that cause any issues? "dominicb" wrote: Good morning Oglu Any macros? Multiple macro editing can cause exessive file size. Alternatively try this. File Save As... Select Web Page as the file type, then Entire Workbook and click OK. Close Excel. Reopen Excel and open the file from the HTML format. Now save the file back as .xls format. Does that decrease the size for you? Don't forget to delete the HTML files - they're no longer needed. HTH **** I've never had a problem using this trick, but only do it on a file you have a recent back up of **** DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=396739 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File size - | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
How do I copy data from a cell in one file to another? | New Users to Excel | |||
Weekly Transaction Processing | Excel Worksheet Functions |