View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Files saved in excel 2002

New versions of excel calculate differently from older versions of excel. So
the first thing that excel does when it opens an older workbook is recalc.
Since the workbook may have changed as the result of the recalculation, you're
prompted to save when you close.

I think that if you wanted to do all your workbooks at once, you'd have to open
each and save each and close each.

I guess you could have a macro that searched all the folders on your harddrive,
all the folders on all your network drives, all the folders on all the
removeable media (CD's, Floppies, Thumbdrives). But personally, that sounds
kind of like a waste of time to me. I'd just save the file using xl2003 the
first time I opened it.


create_share wrote:

I installed office 2003 on my system. It was office 2002 before. Now when i
open any file which was saved in excel 2002, it is asking me to save it again.

Can i transfer all my excel 2002 files to excel 2003 at once rather than
saving one by one?

Thanks!


--

Dave Peterson