Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 28th 07, 12:11 AM posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 408
Default Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat

It appears that all spreadsheets created in Excel 2007 that are saved in the
new XML format (xlsx) are opened as Read-Only files when opened on a machine
running an older version of Excel (Excel 2003) after the Office 2007
Compatibility Update has been applied to that machine. Is this a known issue?

--
Tim McDonald (MCSE)

  #2   Report Post  
Old March 31st 07, 11:12 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,173
Default Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat

Tim

It depends what the file contains from XL2007. Some will as 2007 is trying
to stop users from changing things which will not round trip to 2007 when
re-opened there. e.g some conditional formatting, pivot tables, etc

Shouldn't be that way with all but still the best way to share workbooks is
to save in 2007 as 97-2003

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Tim" wrote in message
...
It appears that all spreadsheets created in Excel 2007 that are saved in
the
new XML format (xlsx) are opened as Read-Only files when opened on a
machine
running an older version of Excel (Excel 2003) after the Office 2007
Compatibility Update has been applied to that machine. Is this a known
issue?

--
Tim McDonald (MCSE)




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 97-2003 files won't open in 2007? Dwyndl Excel Discussion (Misc queries) 3 February 16th 07 04:45 PM
How do I get Excel 2003 to read Excel 2007 files ex-obolobo Excel Discussion (Misc queries) 2 February 10th 07 06:18 PM
cannot open any excel 2003 files with newly installed 2007 beta ritter Setting up and Configuration of Excel 1 October 17th 06 09:21 PM
HOW DO I CONVERT XLSX FILES BACK TO EXCEL 2003? vei Excel Discussion (Misc queries) 5 July 10th 06 09:28 PM
modify xlsx files with excel 2003 mallorypr Excel Discussion (Misc queries) 0 July 10th 06 03:15 PM


All times are GMT +1. The time now is 06:29 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017