PESONAL WORKBOOK PLEASE HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Close Excel
find the workbook personal.xls in the xlstart directory and delete it.

Use file=>Find in the Windows Start
 
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
 
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
 
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
 
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.
 
Back
Top