View Single Post
  #10   Report Post  
Dave Peterson
 
Posts: n/a
Default

Thanks for posting back. Now google has the solution for the next person with
the problem.

wrote:

Hi,

I could solve the problem by removing my local user profile folder and
give Windows the opportunity to recreate my profile and set all
standard settings, xlt, dot, ... files.

Issue doesn't occur any more now.

Thank you all for the replies, informations and your time.

Kind regards,
Dominic

Dave Peterson wrote:
Not from me.

If it still happens in safe mode, I would think you could rule out a macro as
the cause.

Maybe someone who has seen this will jump in.

wrote:

Hi,

I use Windows 2000 SP4.
The formula =("filename",a1) returns the correct filename, also after
the save as and unchanged title bar.
The /safe slash works, but the behaviour still occurs, also in safe
mode.

I have to look to my files to see whether macro's change my title bar.
As far as I know, I never put any code to have the TB changed.

Other ideas?

Dominic

Dave Peterson wrote:
If you open excel in safe mode:

close excel
windows start button|run
excel /safe
file|open yourworkbook

And save it as a new name, does it work ok.

A macro could have changed the window caption and just saving the workbook as a
new name won't fix that.



Dominic wrote:

Hi Dave,

Thanks for the reply.

I test and return with the results and requested info.

Dominic

Dave Peterson wrote in message ...
I've never seen xl do this.

You may want to verify that you're saving to the new file ok.

In an empty cell after the save:
=cell("Filename",a1)

Does it look ok?

(I'm guessing that something is interrupting the SaveAs--but that's a pretty
wild guess!)

======
I don't have a guess why your title bar isn't updated, but you may want to post
the version of Windows you're running to see if others with that same setup can
respond.


Dominic wrote:

Hi,

Situation: I open Excel 2002 (XP), choose a file to open (eg
"myfile.xls") and work in it.

I save a copy via File / Save as. I name it "mynewfile.xls" and click
OK.

File correctly saved; the original still exists on disk. The filename
appears correctly in the File menu in the list of recently used files.

But: the information in the Excel's title bar didn't change: it still
displays the filename of the first file.

If I understand Excel well, it saves a copy of the original file to a
new one, and keeps working with the new one. So the new filename
should appear in the title bar.

I continue working in the new file; I close Excel, open it and open
the copy (mynewfile.xls), all changes I made after the first "save as"
are well kept and saved, and now, Excel displays the correct filename
in the title bar.

Has anyone an idea how to correct the issue with the title bar
information which isn't changing after a "save as"?

I use Excel XP SP3 English (10.6713.6735) and have full local admin
access on my PC / all xls files are stored locally.

thanks in advance for any reply, information, tip or solution!

Dominic

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson