Change in opening Excel??
Hi Gord,
Sorry for the delay in getting back to this but was out of
town. You've probably already read what I found and that
Excel now opens with a new book. Actually I didn't really
need this, but was very curious why it happened. I'm
still not sure where all those .bak files came from, but
they're gone and the program works fine.
Thanks very much for the input.
Have a great day,
DG
-----Original Message-----
DG
Try opening Windows Explorer and ToolsFolder
OptionsFile Types then follow
my first instructions from there.
If you have no Settings on your Start Menu, it is because
you have hidden it.
Are you using the XP option or the Clasic Windows?
Are you running TweakUI and have the Settings turned off
there?
Do you want to have a blank workbook open when you start
Excel?
Do you want it to be virginal or a Template with some
customizing done to it?
Gord Dibben Excel MVP
On Sat, 12 Jun 2004 14:02:43 -0700,
wrote:
Hi Gord,
Thanks for the input but I've looked everywhere for the
sequence you quoted and can't locate a "Settings" option
from the "Start" button. (I assume you're referring to
the Start button on the left of the task bar.)
Have had a couple of others look at this with your
instructions and we're really in the dark here.
Guess I need a primer on this. I'm using XP and
Excel2000. If you don't mind, could you walk me through
this one more time....cause I'm sure missing something.
DG
-----Original Message-----
DG
Go to StartSettingsFolderOptionsFile Types. Scroll
down to MS Excel
Worksheet. Then if running Win98 OS Edit
select "Open"
and Edit.
If using WinXP OS you would scroll down to .XLS
then "Advanced"OpenEdit.
In Command line the path should be similar to this....
"C:\PROGRAM FILES\MICROSOFT
OFFICE\OFFICE\EXCEL.EXE" /e
(delete the sp/e if
you want Book1 to open.
You must have the double quotes.
Below have "use DDE" checked and this in the DDE
message
box....[open("%1")]
Application should read "Excel"(no quotes)
Gord Dibben Excel MVP
On Fri, 11 Jun 2004 19:06:27 -0500, Dave Peterson
wrote:
Next guess...
Check to see if there's something in your XLStart
folder. Maybe there's a
workbook that doesn't belong. Try moving everything
out of there (with excel
closed) and then restart excel to test.
DG wrote:
Hi Dave,
Thanks for the response.
I looked in the Properties of my desktop icon as you
suggest...that's where I normally start Excel from.
Under the "Shortcut" tab the "Target" box is greyed
out
with the following in it..."MicroSoft Office 2000
Premium" (w/o the quotes). No "/e" there or in any
of
the other options.
What next?
Don
-----Original Message-----
One way to stop excel from opening with a new book
visible is to change the
shortcut that you use to start excel.
If you check your shortcut (rightclick on it and
select
properties), look to see
if there's a "/e" (w/o the quotes) at the end of the
Target box.
DG wrote:
Would really like to know what I did and how to
correct
it...??
When I open Excel now, it opens, but not to a new
book,
no to any book. It use to open to a new book.
Not
sure
what I did, but have looked for a setup for this
and
can't find one. Any help would be appreciated.
DG
--
Dave Peterson
.
.
.
|