PC Review


Reply
Thread Tools Rate Thread

Converting Excel 07 to older versions

 
 
=?Utf-8?B?U05T?=
Guest
Posts: n/a
 
      22nd Sep 2007
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 With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      22nd Sep 2007
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" <(E-Mail Removed)> wrote in message
news:AAA8B74C-FC5B-4B49-87FC-(E-Mail Removed)...
>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 With Quote
 
=?Utf-8?B?U05T?=
Guest
Posts: n/a
 
      23rd Sep 2007
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 With Quote
 
David Biddulph
Guest
Posts: n/a
 
      23rd Sep 2007
Close all but one window and save it when only one wondow is left open.
--
David Biddulph

"SNS" <(E-Mail Removed)> wrote in message
news:55B87B17-1A97-49BB-B763-(E-Mail Removed)...
> 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 With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      24th Sep 2007
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" <(E-Mail Removed)> wrote in message
news:55B87B17-1A97-49BB-B763-(E-Mail Removed)...
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Older Versions of Excel excel help Microsoft Excel Misc 1 22nd Sep 2008 12:26 AM
Older versions of Excel Launchnet Microsoft Excel Misc 5 6th Aug 2007 03:50 PM
Using Older versions of ms excel with 2003 =?Utf-8?B?QmFzc0pheQ==?= Microsoft Excel Programming 1 18th Oct 2005 06:41 PM
Compatibility with older versions of Excel ChuckM Microsoft Excel Programming 2 20th Dec 2003 06:47 PM
Numberformat in older versions of Excel Oriana Microsoft Excel Worksheet Functions 8 17th Oct 2003 07:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:37 AM.