Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / April 2008

Tip: Looking for answers? Try searching our database.

2007 Converter No Longer Works

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CityofDenverITGUY - 23 Apr 2008 15:59 GMT
We receive Excel spreadsheets from taxpayers and we are beginning to get many
of them submitted in Office 2007 format.  The File converter for 2003 used to
allow us to open the files but now they do not work on any received files.  
Our users are having to e-mail the documents to their homes, convert them to
2003 using their home Office 2007 versions and then e-mail them back.

We involved MS Technical support and we were told it was likely due to some
addin being used by the sender (OneNote was mentioned).  The only way the
files can be opened in 2007 is through the repair process.  Now certainly all
of our received files are not corrupted.  

I have yet to hear a plausible explanation why the converter does not work.  
I even uninstalled my MS Office 2003, reinstalled, installed the converter
and still these files will not convert.  We desperately need a solution,
short of migrating our entire enterprise over to Office 2007.

After the MS technician repaired the file in Office 2007, I was able to open
it in 2003 using the converter.  Can I send him all our documents?  ;)  Here
is what the MS Technician sent back when we sent him one of the files to open:

Hi John,



I tried to open it as well, and there are problems with the file itself.  It
wouldn't open in Excel 2007 without repairing it.



I ran a repair on it, and here's what was fixed:



<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

 <logFileName>error066240_01.xml</logFileName>

 <summary>Errors were detected in file
'C:\Users\aaronvin\AppData\Local\Microsoft\Windows\Temporary Internet
Files\Content.Outlook\RBUTJTVO\Denver personal property
schedule.xlsx'</summary>

- <additionalInfo>

 <info>Excel completed file level validation and repair. Some parts of this
workbook may have been repaired or discarded.</info>

 </additionalInfo>

- <removedParts summary="Following is a list of removed parts:">

 <removedPart>Removed Part: Print options.</removedPart>

 </removedParts>

 </recoveryLog>



Does the file have a special Print option macro or add-on?



Attached is the repaired file -- does it open for you?



Aaron Vincent

Email: aaronvin@microsoft.com
Nick Hodge - 25 Apr 2008 08:03 GMT
If they send the files in a zip archive, do they open then?  The zip should
protect the file, although a new 2007 file is actually a zip in itself, so
the file size won't reduce.

I notice these are being opened directly from the email which is never a
good idea, save them off somewhere and then open them. Also, if you insist
on opening them directly from emails make sure the temp internet folders of
all users are empty.

In the example below

'C:\Users\aaronvin\AppData\Local\Microsoft\Windows\Temporary Internet Files\

Everything can be deleted.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

> We receive Excel spreadsheets from taxpayers and we are beginning to get
> many
[quoted text clipped - 68 lines]
>
> Email: aaronvin@microsoft.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.