Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2007 Files Are Now Saving with Fewer KB in Both Excel 2007 and 2

08 Jun 2016   #1
Geophyte1

Windows 7 Professional 64bit
 
 
Excel 2007 Files Are Now Saving with Fewer KB in Both Excel 2007 and 2


The “problem” I’m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb.
I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit.The W700 has Office 2007 and theW541 has Office 2013.Both versions ofExcel are 32 bit as far as I can tell.
Until recently I was primarily using the W700ds but have nowswitched to the W541.


after I saw a larger file losing KB when saved, I did a test with a file that had not been altered or openedfor over two years. I copied it twiceand added a -1 and a -2 to change the names.The file was a small 832 Kb file.When I opened and saved on the W541 running Windows 7 with Excel 2013,the file saves with 771 Kb.When Iopened the file using the W700 running Windows 7 with Excel 2007, the computeron which it had originally been created, the file saved as 830 Kb.Both saved smaller but the newer computerrunning Excel 2013 was much smaller.Iam seeing these same types of ratios of reduction in size for much larger Excelfiles as well.

I have not documented any actual problems or loss of data withany of the files to date and I have used an Ultra-Compare text file comparison which found no differences.
Is there any reason to be concerned about this? And, if so, what to do?

As with many people, some of my files are the result of manyyears of work and I don't want to do anything to compromise any of the data butI don’t know whether or not what I’m seeing is normal due to both Excel 2007and Excel 2013 becoming somehow more efficiently programmed than previousversions of Excel 2007.
I have systems whereby I backup/sync files to a home networkNAS HD. I also sync between thecomputers.

Your help will be greatly appreciated.



My System SpecsSystem Spec
.
08 Jun 2016   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Hi & welcome to the Forum.

I don't think there is anything to worry about, but keep a watch on it just in case. Have you done a Disc Defrag lately, if so that might explain it.

Just to be safe run a regular back up of your system, which you should be doing anyway.
My System SpecsSystem Spec
08 Jun 2016   #3
Geophyte1

Windows 7 Professional 64bit
 
 

Thank you for your thoughts. I do wonder if it could possibly be involved with the "compatibility" issue between the old xls files and the xlsx files. All of the files I've been talking about have been xlsx files for a long time now but it is very possible that they were all xls files at one time.

I'm also curious to know if anyone else has seen a "problem" of this nature. I do back up my files often and when I noticed this issue I made it a point to backup to a HD that will not be changed in the future so that i could go back to most of the unaltered files if necessary. Even that does not change the fact that even the Excel 2007 is reducing file size.
My System SpecsSystem Spec
.

08 Jun 2016   #4
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit
 
 

I had not heard of your issue, but just did the following.

I found an Excel file on my system with an xls extension. The modified date on it was from 2007. At that time, I would have had Office 2007 or 2003.

It was 17,920 bytes in size.

I opened it, made no modifications, and closed it within 3 seconds. I didn't do a "save as" or anything like that. It's still an xls file.

It is now 27,648 bytes in size. The modified date on this file now shows today's date, even though I did not modify it--I just opened and closed it. I have no idea if this is standard behavior.

I found another file, modified in 2010, with an xls extension. At that time, I had Office 2007.

1,579,008 bytes. I opened it and closed it within 3 seconds. The file size did not change.

I have no idea why the size changed on the first file, but not on this second file.

I found a third file, modified in 2007. XLS extension. 53,760 bytes. I opened it and closed it within 3 seconds. No change in file size.

I then reopened this third file and saved it as an xlsx file. Size 32,514 bytes.

Make of that what you will.
My System SpecsSystem Spec
08 Jun 2016   #5
Geophyte1

Windows 7 Professional 64bit
 
 

Thank you for that experimental result. It is looking more probable that my recent xlsx file size reductions may well have some tie to their having been xls files at one time.
I suppose I'll play like there is not a data problem and proceed full steam ahead
My System SpecsSystem Spec
08 Jun 2016   #6
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit
 
 

Quote   Quote: Originally Posted by Geophyte1 View Post
Thank you for that experimental result. It is looking more probable that my recent xlsx file size reductions may well have some tie to their having been xls files at one time.
I suppose I'll play like there is not a data problem and proceed full steam ahead
Yeah, I guess that's what I'd do.

I can see why different versions of Excel might result in different file sizes, due to more efficient code.

But that fact alone would not explain all of the results I noted in my earlier post--such as the mere opening and closing of an xls file causing a change in file size.

Which reminds me:

Are you keeping track of recent Office releases?

I am wondering about this issue:

What is the most recent version of Office that is NOT connected with the cloud, does NOT involve a subscription, and is FULLY transferable from an existing computer to a newly built computer with entirely new components? Just like it was 10 years ago.

I ask this because I currently have Office Home and Student 2010 and may some day want to upgrade to a newer version, but I refuse to get involved with subscriptions or the cloud. The last I checked, there was no newer version that met my criteria.

Any help?
My System SpecsSystem Spec
08 Jun 2016   #7
Geophyte1

Windows 7 Professional 64bit
 
 

I have to admit to knowing less about the issue than you obviously do. I do not keep up with the latest versions. I'm running Office 2013 because that is what came with my W541 but you are making me think about checking up on the issues you mentioned.
My System SpecsSystem Spec
Reply

 Excel 2007 Files Are Now Saving with Fewer KB in Both Excel 2007 and 2




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Excel 2007 files are corrupted.
Hi all! Two days ago I have saved my workbooks on the mapped network drive, but now all files are corrupted.:cry: Excel tries to recover the corrupted data everytime I want to open it, but with no success. I removed all the links to external spreadsheets and read some topics with similar...
Microsoft Office
Error on saving MS Office Excel 2007 files to MS Office 2013
We have an upgrade on our computer units here in the company, my problem is when users save their 2007 excel files an error pops up, Errors were detected while saving "File Name". Microsoft maybe able to save the file by removing or repairing some features. To make the repairs in new file, click...
Microsoft Office
Excel 2007 (MS Office 2007 enterprise)
I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells. I have cleared the cells formatted the number but it still keeps on...
Microsoft Office
Can I view linked excel 2007 files in IE9?
In XP, and previous IE's we'd click on a link to an excel file and it would pop up within IE, so we could quickly view it. I would like this in IE9, does anyone know how to make this happen? I have not had luck searching for a solution to this in Windows 7/IE9 Thanks!
Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 07:37.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App