Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
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  
Posted to microsoft.public.excel.misc
external usenet poster
 
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 09:17 PM.

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

About Us

"It's about Microsoft Excel"