PESONAL WORKBOOK PLEASE HELP

D

DanielWalters6

When ever I open Excel it doesn't open with a blank workbook as per normal,
(eg. workbook1 or 4 or something) it opens with PERSONAL.

I am not sure how I did this, I think it may have been a macro,(that's why
I';ve put it in programming) I've tried deleting all the macros that I can
find and it's still doing this.

Please if anyone knows how to stop this, could you please help me

Thankyou for your help in advance

Dan
 
D

Dave Peterson

If you're sure you don't have any macros that are in personal.xls that you want
to keep, you can delete that workbook (or move it somewhere else if you want).

Next time you open excel, type this in a cell in personal.xls
=cell("Filename",a1)

Note the location of that file.

Close excel.
Use windows explorer to go to that folder.
Either move personal.xls to a different folder or just delete it.
 
T

Tom Ogilvy

Close Excel
find the workbook personal.xls in the xlstart directory and delete it.

Use file=>Find in the Windows Start
 
D

DanielWalters6

After many failed attemtps (not sure why)

It finally worked.

thank you for your time

Dan
 
G

Gord Dibben

Dan

As an alternative you could always "Hide" Personal.xls so's it opens but is
hidden from view.

With it open go to Windows>Hide then close Excel. Click "Yes" when asked to
save changes to Personal.xls.

Then any global macros will be available for any and all open workbooks.

That is the function of the Personal.xls workbook.


Gord Dibben Excel MVP
 
D

DanielWalters6

Thankyou, but I don't regularly use the same macros.

Thank you for your help all the same. Have made a mental note of a few way
in which I can hide a workbook in future.

P.s. You know how you can make two workbooks open at the same time? Eg. when
creating a shortcut to a file, can you make it so that it opens two?

Or when I was to open one workbook, another one would open hidden.

Thank's for the help

Dan
 
G

Gord Dibben

Dan

You can place the hidden workbook in your XLSTART or Alternate startup folder
designated at Tools>Options>General and it will open hidden whenever Excel is
started.

If always to be the same file you can have a shortcut to any other file and
both will open, one of them hidden.

I can't think of any way to open two files from a single shortcut.


Gord
 
A

Alojz

Daniel, don't you mean opening same file in two or more windows?
You can do that by clicking on Window->New Window. Then arrange according ur
need.
 
Top