PERSONAL.XLSB


J

Joe

Hi

I have the following problem...

I recorded I macro and chose to save in the Personal macro workbook.

After closing and saving the files, a file named PERSONAL.XLSB is found in
the path

C:\Documents and Settings\<username>\Dados de
aplicativos\Microsoft\Excel\XLINÍCIO

I'm using the EXCEL 2007 Brazilian Portuguese version.

The problem: opening Excel, the PERSONAL.XLSB file is NOT opened
automatically, as should be.

How can I fix this problem?

Thanks in advance for your anwser.

Joe
 
Ad

Advertisements

P

Peter T

I only have English Excel, not sure but look at this key in the registry

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General\Xlstart

The value I have is XLSTART which is what I'd expect in my English version,
but you should have XLINÍCIO. If not try changing it (but be sure you can
restore the previous setting if necessary).

If that works you will also want to ensure the path is in a Trusted
Location.
Excel Options/Trust Center/Trusted Locations

You can also look in the registry
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\Trusted
Locations\

Ah but if you only have an XLSB that might not be necessary (unusual,
normally XLSM to store macros)

Regards,
Peter T
 
J

Joe

Hi Peter

Thanks for your help.

The entries in the Registry has the values expected, as you had mentioned.

I also don't kwow why there is a XLSB file instead of a XLSM.

I opened the Personal.XLSB and then I saved it as a XLSM, keeping the file
attribute to hidden: it works!

Any file I put in the folder is opened, as should be.

I think this is a BUG of this Brazilian Portuguese version.

Do you know how this can be reported to Microsoft?

Thanks again.

Joe
 
P

Peter T

Hi Joe,

I could report a bug for you, however I very much doubt it is a bug. Why -
if it was a bug we would have seen hundreds of similar reports, but this is
the first time I have heard of your problem (OK I'm sure you are not the
only one).

First of all Personal does indeed get saved by default as XLSB, even with
macros. I still use my old Personal.xls, so I never noticed.

I suggest you start again -
drag all modules from your Personal into a new workbook and save it
Close Excel
Rename XLINÍCIO to say XLINÍCIOtmp
Make a new Personal,
start recording a macro, in the dialog which asks you where you want to
store the macro select Personal.
Do something, say select B2 and stop recording.
Close Excel
At the prompt allow Excel to save Personal (don't save it yourself)
Re-Open Excel
Hopefully your Personal will open, if it does delete that macro and
re-import your old modules.
If it doesn't....
did Excel create a new XLINÍCIO folder with Personal saved inside it?

Regards,
Peter T
 
J

Joe

Hi Peter

Let me explain what I am doing.

I work as instructor and developer of solutions based in MS Office.

I'm reformulating a Excel VBA course and its manual.

As I've been working for more than 15 years with this products.

So, as I'm rewriting the manual, I have to be sure if the Practice match
the Theory.

Then, here we are.

------------------

I did what you asked, although I had already done.

I have the two versions in my computer: 2003 and 2007.

For version 2003, in brazilian portuguese version, the folder name is
XLINICIO instead of XLSTART.

For version 2007, the folder name is XLINÍCIO (with the acute accent),
instead of XLSTART.

I renamed the both folders and did the tests...

Excel 2003: I recorded a macro, closed Excel and saved the file.

A folder named XLINICIO was created within a file named PESSOAL.XLS.

Runnin Excel 2003, a empty pattern workbook is opened and the file
PESSOAL.XLS is already opened and remains hidden.

As it should be.

Doing the same for Excel 2007...

A folder named XLINÍCIO was created within a file named PERSONAL.XLSB.

Runnin Excel 2007, a empty pattern workbook is opened and nothing more
occurs. The file PERSONAL.XLSB is not opened.

The Trust Center is correctly configured.

By renaming the file PERSONAL.XLSB to PESSOAL.XLSB, running Excel, the file
is opened and remains hidden BUT no empty pattern workbook is available.
The Excel window remains gray (empty). So the file PESSOAL.XLSB is
considered as a common file.

By just renaming the file PERSONAL.XLSB to PERSONAL.XLSM, an error message
is shown informing that the file format or the extension is not correct.

---

So, my conclusion at this point is that we have a bug in the brazilian
portuguese version.


In the following weeks I will try to make tests in computers in another
environment, with another version installed.

I will sinalize the result.


If you have another orientation, please let me know.


Thanks again for your help.


Joe
 
P

Peter T

You have given a very detailed description but could you confirm a couple of
small things which seem to be different between your 2003 & 2007

In 2003 you say the created folder is XLINICIO (without an accent)
In 2007 you say the created folder is XLINÍCIO (with an acute accent)

In 2003 the file is named PESSOAL.XLS
In 2007 the file is named PERSONAL.XLSB

This part is very strange -
Runnin Excel 2007, a empty pattern workbook is opened and nothing more
occurs. The file PERSONAL.XLSB is not opened.

*All* files in the start folder should open, including PERSONAL.XLSB even if
that is not truly recognized as the Personal file.
But if you rename the file to PESSOAL.XLSB then it does open but as an
ordinary file, hidden so you will not see any default file (this aspect
makes sense if this name is not recognized as the Personal.

I understand why you feel it is a bug. However if it is a bug that impacts
many people I'm surprised not only I don't know about it but nobody else has
confirmed in this thread. In my experience reporting as a bug to MS will not
get very far unless it can be reproduced. Almost certainly the person who
"triages" the report will not be able to reproduce it. Possibly there is
something else about your overall setup that is causing the problem.

In the meantime hopefully this workaround will enable a default workbook to
open and also a file that's similar to your Personal, albeit not a truly a
Personal.
Name the file to anything that will open (eg PESSOAL.XLSB) and keep it in
the start folder.
Create a new workbook
SaveAs the new workbook as a template in the start folder with the
Portuguese equivalent of this name
Book1.xltx
Change "Book" to the Portuguese name of a default workbook, but be sure to
add the "1".

Regards,
Peter T
 
Ad

Advertisements

B

Barbara Moore

I do not want the worksheets Personal and Practice to open everytime I open Excel...How do you delete them?
Thanks.



Joe wrote:

PERSONAL.XLSB
16-Feb-10

H

I have the following problem..

I recorded I macro and chose to save in the Personal macro workbook

After closing and saving the files, a file named PERSONAL.XLSB is found i
the pat

C:\Documents and Settings\<username>\Dados d
aplicativos\Microsoft\Excel\XLIN?CI

I am using the EXCEL 2007 Brazilian Portuguese version

The problem: opening Excel, the PERSONAL.XLSB file is NOT opene
automatically, as should be

How can I fix this problem

Thanks in advance for your anwser

Joe

Previous Posts In This Thread:

PERSONAL.XLSB
H

I have the following problem..

I recorded I macro and chose to save in the Personal macro workbook

After closing and saving the files, a file named PERSONAL.XLSB is found i
the pat

C:\Documents and Settings\<username>\Dados d
aplicativos\Microsoft\Excel\XLIN?CI

I am using the EXCEL 2007 Brazilian Portuguese version

The problem: opening Excel, the PERSONAL.XLSB file is NOT opene
automatically, as should be

How can I fix this problem

Thanks in advance for your anwser

Joe

I only have English Excel, not sure but look at this key in the
I only have English Excel, not sure but look at this key in the registr

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General\Xlstar

The value I have is XLSTART which is what I'd expect in my English version
but you should have XLIN?CIO. If not try changing it (but be sure you ca
restore the previous setting if necessary)

If that works you will also want to ensure the path is in a Truste
Location
Excel Options/Trust Center/Trusted Location

You can also look in the registr
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\Truste
Locations

Ah but if you only have an XLSB that might not be necessary (unusual
normally XLSM to store macros

Regards
Peter T

Hi PeterThanks for your help.
Hi Pete

Thanks for your help

The entries in the Registry has the values expected, as you had mentioned

I also do not kwow why there is a XLSB file instead of a XLSM

I opened the Personal.XLSB and then I saved it as a XLSM, keeping the fil
attribute to hidden: it works

Any file I put in the folder is opened, as should be

I think this is a BUG of this Brazilian Portuguese version

Do you know how this can be reported to Microsoft

Thanks again

Jo




"Peter T" <[email protected]> escreveu na mensagem

Hi Joe,I could report a bug for you, however I very much doubt it is a bug.
Hi Joe

I could report a bug for you, however I very much doubt it is a bug. Why
if it was a bug we would have seen hundreds of similar reports, but this i
the first time I have heard of your problem (OK I am sure you are not th
only one)

First of all Personal does indeed get saved by default as XLSB, even wit
macros. I still use my old Personal.xls, so I never noticed

I suggest you start again
drag all modules from your Personal into a new workbook and save i
Close Exce
Rename XLIN?CIO to say XLIN?CIOtm
Make a new Personal
start recording a macro, in the dialog which asks you where you want t
store the macro select Personal
Do something, say select B2 and stop recording
Close Exce
At the prompt allow Excel to save Personal (do not save it yourself
Re-Open Exce
Hopefully your Personal will open, if it does delete that macro an
re-import your old modules
If it does not...
did Excel create a new XLIN?CIO folder with Personal saved inside it

Regards
Peter T

Hi PeterLet me explain what I am doing.
Hi Pete

Let me explain what I am doing

I work as instructor and developer of solutions based in MS Office

I am reformulating a Excel VBA course and its manual

As I have been working for more than 15 years with this products.

So, as I am rewriting the manual, I have to be sure if the Practice match
the Theory.

Then, here we are.

------------------

I did what you asked, although I had already done.

I have the two versions in my computer: 2003 and 2007.

For version 2003, in brazilian portuguese version, the folder name is
XLINICIO instead of XLSTART.

For version 2007, the folder name is XLIN?CIO (with the acute accent),
instead of XLSTART.

I renamed the both folders and did the tests...

Excel 2003: I recorded a macro, closed Excel and saved the file.

A folder named XLINICIO was created within a file named PESSOAL.XLS.

Runnin Excel 2003, a empty pattern workbook is opened and the file
PESSOAL.XLS is already opened and remains hidden.

As it should be.

Doing the same for Excel 2007...

A folder named XLIN?CIO was created within a file named PERSONAL.XLSB.

Runnin Excel 2007, a empty pattern workbook is opened and nothing more
occurs. The file PERSONAL.XLSB is not opened.

The Trust Center is correctly configured.

By renaming the file PERSONAL.XLSB to PESSOAL.XLSB, running Excel, the file
is opened and remains hidden BUT no empty pattern workbook is available.
The Excel window remains gray (empty). So the file PESSOAL.XLSB is
considered as a common file.

By just renaming the file PERSONAL.XLSB to PERSONAL.XLSM, an error message
is shown informing that the file format or the extension is not correct.

---

So, my conclusion at this point is that we have a bug in the brazilian
portuguese version.


In the following weeks I will try to make tests in computers in another
environment, with another version installed.

I will sinalize the result.


If you have another orientation, please let me know.


Thanks again for your help.


Joe

You have given a very detailed description but could you confirm a couple
You have given a very detailed description but could you confirm a couple of
small things which seem to be different between your 2003 & 2007

In 2003 you say the created folder is XLINICIO (without an accent)
In 2007 you say the created folder is XLIN?CIO (with an acute accent)

In 2003 the file is named PESSOAL.XLS
In 2007 the file is named PERSONAL.XLSB

This part is very strange -


*All* files in the start folder should open, including PERSONAL.XLSB even if
that is not truly recognized as the Personal file.
But if you rename the file to PESSOAL.XLSB then it does open but as an
ordinary file, hidden so you will not see any default file (this aspect
makes sense if this name is not recognized as the Personal.

I understand why you feel it is a bug. However if it is a bug that impacts
many people I am surprised not only I do not know about it but nobody else has
confirmed in this thread. In my experience reporting as a bug to MS will not
get very far unless it can be reproduced. Almost certainly the person who
"triages" the report will not be able to reproduce it. Possibly there is
something else about your overall setup that is causing the problem.

In the meantime hopefully this workaround will enable a default workbook to
open and also a file that is similar to your Personal, albeit not a truly a
Personal.
Name the file to anything that will open (eg PESSOAL.XLSB) and keep it in
the start folder.
Create a new workbook
SaveAs the new workbook as a template in the start folder with the
Portuguese equivalent of this name
Book1.xltx
Change "Book" to the Portuguese name of a default workbook, but be sure to
add the "1".

Regards,
Peter T


Submitted via EggHeadCafe - Software Developer Portal of Choice
C# And The Little Iterator That Could
http://www.eggheadcafe.com/tutorial...32-0ae26adaa533/c-and-the-little-iterato.aspx
 
G

Gord Dibben

Move or delete them from your XLSTART folder.

BTW.........Personal.xls is not a worksheet................is a workbook.

I don't know what "Practice" is but I'll bet it is also a workbook.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

P

Peter T

As Gord Dibben suggests look at the XLSTART folder. What's slightly odd
though is your mention of "Tabs" in the subject line. Normally the Personal
workbook is hidden and you wouldn't see any tabs. If you want your Personal
workbook to open normally, which it does automatically if in the XLSTART
folder, but not see the tabs you need to "hide" the workbook. The way to do
that is slightly different in Excel 2007 and earlier versions (post back if
not sure how but state version). Close Excel and at the prompt asking if you
want to save Personal click Yes.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top