Profile effecting Excel
 

When i open any Excel file it is automatically prefixed with "Book 1", even
if i open a new workbook it is named "Book 1 - Book 3" (Book 3 being the
correct new name). I have tried logging onto someone else's PC (on the same
network) and get the same result so it points to something to do with my
profile.

Does anyone have any ideas what is causing this
--
with kind regards

Spike

Profile effecting Excel
 

You open existing workbooks and you see this in the title bar?

If you put this in an empty cell in any of the worksheets, what do you see:

=cell("address",a1)

It should show you the complete path and filename of that already saved
workbook.

Do you see "book 1 - Book 3" in the name?

If you don't, maybe it's just the title bar that's getting screwed up.

You can try this:
alt-f11 (to get to the VBE where macros live)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.Caption = ""

Then type this and hit enter:
activewindow.Caption = ""

Did that help?

Maybe you have a helpful macro that takes control of the caption bars.

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm

These may help you find where that "helpful" macro is coming from.

Spike wrote:

When i open any Excel file it is automatically prefixed with "Book 1", even
if i open a new workbook it is named "Book 1 - Book 3" (Book 3 being the
correct new name). I have tried logging onto someone else's PC (on the same
network) and get the same result so it points to something to do with my
profile.

Does anyone have any ideas what is causing this
--
with kind regards

Spike

--

Dave Peterson

Profile effecting Excel
 

Change this:
=cell("address",a1)
to
=cell("filename",a1)

(muscle memory screwed me up!)



Dave Peterson wrote:

You open existing workbooks and you see this in the title bar?

If you put this in an empty cell in any of the worksheets, what do you see:

=cell("address",a1)

It should show you the complete path and filename of that already saved
workbook.

Do you see "book 1 - Book 3" in the name?

If you don't, maybe it's just the title bar that's getting screwed up.

You can try this:
alt-f11 (to get to the VBE where macros live)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.Caption = ""

Then type this and hit enter:
activewindow.Caption = ""

Did that help?

Maybe you have a helpful macro that takes control of the caption bars.

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm

These may help you find where that "helpful" macro is coming from.

Spike wrote:

When i open any Excel file it is automatically prefixed with "Book 1", even
if i open a new workbook it is named "Book 1 - Book 3" (Book 3 being the
correct new name). I have tried logging onto someone else's PC (on the same
network) and get the same result so it points to something to do with my
profile.

Does anyone have any ideas what is causing this
--
with kind regards

Spike

--

Dave Peterson

--

Dave Peterson