+ Post New Thread
Results 1 to 14 of 14
Office Software Thread, Compatibility Pack opens files read-only in Technical; We have the Office 2007/2010 compatibility update installed site-wide, and this works fine on all except one computer. Generally, when ...
  1. #1
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75

    Compatibility Pack opens files read-only

    We have the Office 2007/2010 compatibility update installed site-wide, and this works fine on all except one computer. Generally, when you open a xlsx file, Excel launches and then says it is converting the file, which then opens; on this one computer, however, a dialog box appears before Excel opens saying it is converting, and Excel then launches with the spreadsheet open but called X000001.xls [Read-Only], which is saved in a local temp file somewhere.

    Any ideas? I've tried re-installing the compatibility update, and even re-installed Office, but without success.

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,040
    Thank Post
    374
    Thanked 372 Times in 303 Posts
    Blog Entries
    8
    Rep Power
    177
    Are there any other MS updates to apply on this PC?

  3. #3
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Just the usual monthly updates, all of which should be on.

  4. #4

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,040
    Thank Post
    374
    Thanked 372 Times in 303 Posts
    Blog Entries
    8
    Rep Power
    177
    It could be a legacy issue stored in the profile. Try deleting that profile (or a test one)? Or even simpler, use a new/different account and see if the same issue?

  5. #5
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Don't think so - all users (including my administrative one) are affected. Also, the same users are unaffected on other computers.

  6. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,040
    Thank Post
    374
    Thanked 372 Times in 303 Posts
    Blog Entries
    8
    Rep Power
    177
    Unknown then, but I wouldn't spend too much extra time on it if you could rebuild the PC just as quickly? Unless of course someone has a bright idea soonish?

  7. #7

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,752
    Thank Post
    1,278
    Thanked 1,651 Times in 1,106 Posts
    Blog Entries
    22
    Rep Power
    506
    Compare the file associations on the effected machines and the working machines.
    This can happen if the 2007 file formats are passed to something like.. can't rememeber the exact program but something like 'MS XML processor' before going to excel.

  8. #8
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    I've got this as well on a teacher laptop - current workaround is to open Excel first then use file-open, which works fine

  9. #9

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,752
    Thank Post
    1,278
    Thanked 1,651 Times in 1,106 Posts
    Blog Entries
    22
    Rep Power
    506
    Quote Originally Posted by sparkeh View Post
    Compare the file associations on the effected machines and the working machines.
    This can happen if the 2007 file formats are passed to something like.. can't rememeber the exact program but something like 'MS XML processor' before going to excel.
    Just checked, make sure .xlsx files are associated with Excel and not with Microsoft Open XML Converter

  10. #10
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Rebuild isn't ideal given the location of the computer (it could wait until Christmas hols, though); File>Open would work, but isn't generally the way people access their files.

    I'll check sparkeh's suggestion for file associations...

  11. #11

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,040
    Thank Post
    374
    Thanked 372 Times in 303 Posts
    Blog Entries
    8
    Rep Power
    177
    Quote Originally Posted by enjay View Post
    Rebuild isn't ideal given the location of the computer (it could wait until Christmas hols, though); File>Open would work, but isn't generally the way people access their files.

    I'll check sparkeh's suggestion for file associations...
    Of course it isn't ideal, and is a lame suggestion (to most things!) but is worth a consideration only against how long you might spend on solving the problem. solve in a day? cool. Solve in a week? not so cool

  12. #12
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Quote Originally Posted by GREED View Post
    Of course it isn't ideal, and is a lame suggestion (to most things!) but is worth a consideration only against how long you might spend on solving the problem. solve in a day? cool. Solve in a week? not so cool
    There is also the impact on the user to consider, though. I could rebuild the PC which would get the problem off my desk in 5 minutes but mean they can't use their computer for 4 hours, or I could spend 30 minutes spread across a few days finding a solution which can then be applied in 5 minutes.

  13. #13

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,040
    Thank Post
    374
    Thanked 372 Times in 303 Posts
    Blog Entries
    8
    Rep Power
    177
    Quote Originally Posted by enjay View Post
    There is also the impact on the user to consider, though. I could rebuild the PC which would get the problem off my desk in 5 minutes but mean they can't use their computer for 4 hours, or I could spend 30 minutes spread across a few days finding a solution which can then be applied in 5 minutes.
    Of course, and that 30 minutes is nothing, so you have the right plan. I am a Trainer and work with IT apprentices, and one thing these very technical guys don't do is if they have an issue, look at the quickest, most suitable and most permenant solution, as opposed to scouring the internet forums for a hack or fix or flash that takes days and days. One chap spent 3 weeks trying to fix a switch issue with flashes and hacks, and a quick call the manufacturer would have found it was a fault with the model. Boss was not pleased!

  14. #14
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Quote Originally Posted by sparkeh View Post
    Just checked, make sure .xlsx files are associated with Excel and not with Microsoft Open XML Converter
    Yeah, spot on sparkeh, that's the problem.

    The thing is, I can't enter the correct information in there. Checking a working PC, the files should be set to open with Excel, and under the Advanced section, the &open command should run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e, but whenever I enter that manually, it decides to add a %1 at the end, and then doesn't work.

SHARE:
+ Post New Thread

Similar Threads

  1. Visio Shortcut Opens Multiple VBS Files?
    By DaveP in forum How do you do....it?
    Replies: 0
    Last Post: 14th July 2010, 12:48 PM
  2. Deploying the Office 2007 Compatibility Pack
    By edcirh in forum Office Software
    Replies: 15
    Last Post: 19th November 2009, 09:06 AM
  3. Office 2007 Compatibility Pack Problem
    By shane-meh in forum Office Software
    Replies: 5
    Last Post: 6th November 2009, 12:25 PM
  4. Office 2007 Compatibility Pack Deploy using MSI
    By LOUD in forum Windows Server 2000/2003
    Replies: 4
    Last Post: 13th August 2009, 02:56 PM
  5. Office 2007 Compatibility Pack SP1
    By cookie_monster in forum Windows
    Replies: 16
    Last Post: 19th February 2009, 02:37 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •