Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |