| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Excel 07 to older versions
I quite often set up workbooks in 07 for use in older versions of excel. But
when the older version is opened it opens as 4 separate workbooks. Each are the same. You can save changes in that version and when it is opened again it is still 4 books. Is there away to convert 07 to stop this happening? -- Simon |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Excel 07 to older versions
Four workbooks? Or four windows for the same workbook? Does it say
Book1.xls:1, :2, etc., in the window title bar? You can close the individual windows, leaving one open. Does it happen all the time? Do you notice the multiple windows in 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "SNS" wrote in message ... I quite often set up workbooks in 07 for use in older versions of excel. But when the older version is opened it opens as 4 separate workbooks. Each are the same. You can save changes in that version and when it is opened again it is still 4 books. Is there away to convert 07 to stop this happening? -- Simon |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Excel 07 to older versions
It is 4 windows and yes it happens each time. No it doesn't happen in 2007
-- Simon "SNS" wrote: I quite often set up workbooks in 07 for use in older versions of excel. But when the older version is opened it opens as 4 separate workbooks. Each are the same. You can save changes in that version and when it is opened again it is still 4 books. Is there away to convert 07 to stop this happening? -- Simon |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Excel 07 to older versions
Close all but one window and save it when only one wondow is left open.
-- David Biddulph "SNS" wrote in message ... It is 4 windows and yes it happens each time. No it doesn't happen in 2007 -- Simon "SNS" wrote: I quite often set up workbooks in 07 for use in older versions of excel. But when the older version is opened it opens as 4 separate workbooks. Each are the same. You can save changes in that version and when it is opened again it is still 4 books. Is there away to convert 07 to stop this happening? -- Simon |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Excel 07 to older versions
The safest thing to do then is to use 2003 to set up the workbooks.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "SNS" wrote in message ... It is 4 windows and yes it happens each time. No it doesn't happen in 2007 -- Simon "SNS" wrote: I quite often set up workbooks in 07 for use in older versions of excel. But when the older version is opened it opens as 4 separate workbooks. Each are the same. You can save changes in that version and when it is opened again it is still 4 books. Is there away to convert 07 to stop this happening? -- Simon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Older versions of Excel | Excel Discussion (Misc queries) | |||
| Opening .xlsm workbooks in older versions of excel | Excel Discussion (Misc queries) | |||
| using Excel 2003 protected sheets with older versions of Excel | Excel Discussion (Misc queries) | |||
| Force cursor to appear in only one cell, older Excel versions | Excel Discussion (Misc queries) | |||
| How can I verify that an Excel file will work with older versions | Excel Discussion (Misc queries) | |||
Hybrid Mode
