View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Matt Jensen Matt Jensen is offline
external usenet poster
 
Posts: 113
Default Updating references in earlier versions

Yeah, not being very clear am I, after saving as xl5 I then opened in 97 and
started building from there (I think that's what I did!)
hth
Matt

"Tom Ogilvy" wrote in message
...
97-2002/5.0 format saves the file with two different file formats, one
97-2002 and one 5.0. So it would make you file much bigger.

Saving in xl5 format would remove any use of userforms, activeX controls

or
commandbars.

--
Regards,
Tom Ogilvy


"Matt Jensen" wrote in message
...
Oh yeah btw saving Excel as 97-2002/5.0 didn't help given 97-2002

apparently
use same file format but somewhere the file knows which version you

saved
in
and there doesn't appear to be a way to change it.
Matt

I've been having a number of problems after developing in xl2002 and

running
on xl97, and ended up saving as 95 and then rebuilding what

functionality