How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9655
Experience:  Vast experience in Excel programming and business solutions
Type Your Programming Question Here...
John D is online now
A new question is answered every 9 seconds

Personal.xlsb does not display in Excel 2010 when I open the

Customer Question

Personal.xlsb does not display in Excel 2010 when I open the program. I need it to create a macro. How do I find it?
Submitted: 2 years ago.
Category: Programming
Expert:  John D replied 2 years ago.

Hi,

 

You don't need the personal.xlsb file to create a macro. What do you want to macro to do?

 

 

 

 

Customer: replied 2 years ago.
I have 2 Windows 7 Laptops each wvith Office 2010 PRo and have previously written a macro to insert A: in front of over 3000 share stocks downloaded each night. This is necessary to be processed by Quicken's Investment program which provides financial info on my share portfolio. I am an amateur in macros but the program I devised works fine on each of the laptops and each of them automatically displayed Personal.XSLB when Excel 2010 opened but the new desktop did not. The program covers 4 A4 pages of instructions. I have searched the internet for answers about finding Personal.xlsb but could find nothing appropriate to Excel 2010.
Expert:  John D replied 2 years ago.

Ok what you need to do is find the file "personal.xlsb" on the computer that has that file, copy it, then save it back in the same folder on the new computer

 

In Windows 7 the personal.xlsb file is typically located in this folder

 

C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB

 

You may however need to set your folder options to show hidden files

 

Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

Customer: replied 2 years ago.

It is easy to place a finger a little bit out with Windows 7/Office 2010 and text just disappears - it has happened twice while attempting to respond. i will try again.

 

I have copied the Personal,xlsb file from one of my laptops to the new desktop.

 

Queries:

 

1. In brand new Excel 2010 why wasn't this all important file present to start with as it was with both my laptops - identical OS and identical Excel 2010?

 

2. I believe there is a Hide and Unhide function for Personal.xlsb. How do i locate that if I need it?

 

3.The Seach function in Windows 7 is no good for file searches whereas Windows XP was excellent. My seach in the laptop for the file came up with 30 plus answers, not one gave me what I needed but I had to wade through all those answers with nothing appropriate in any of them.

 

I downloaded the usual 2000 plus share prices tonight in csv format into Excel. Two seconds after pressing Ctrl + c all had the A: inserted in front. e.g. BHP became A:BHP etc.

 

Good result and with your input on the above this enquiry can be put to bed.

Thanks & Compliments of the Season.

XXXX XXXXX

 

Expert:  John D replied 2 years ago.

Dean, I am not sure I understand your last queries. If however you were able to copy the personal file to the new computer then I would understand that the macros are now working on the new computer. Is so then your initial question has been resolved and you need to click the Accept button so I can get compensated. I will then continue to help you with any other issue you may have

 

Customer: replied 2 years ago.

My understanding is that Personal.xlsb is present in the Excel program as it comes. Certainly I did not put it into either of my laptops which have Excel 2010 also. My query to you is "Why wasn't it there to start with in the new computer Excel 2010? Does this mean that Excel in the new PC is faulty?

You have not answered question 2 re Hide and Unhide .

Although Question 3 is really an observation about the difficulty I had following your suggestion to source the file in the laptop, I was hoping that you may have been able to advise me how to find a file as the new Search feature does not appear to do it. Anything but it would seem! Is there another more reliable method to source file addresses now Windows Search no longer does this?

 

Expert:  John D replied 2 years ago.

I am not sure where this is going. I have answered your original question (which did not include the Hide/Unhide issue). I will be happy to look into this Hide/Unhide but you to release payment so I make sure I get paid for my time

 

Thank you

 

Customer: replied 2 years ago.

John, this is getting to the ridiculous stage. OK if you are not going to answer the HIDE question I accept that was not part of the original question, so forget about that. However you keep ignoring my question 1 about Personal.xlsb not being in the new PC. Also the query about the search problem for the file is directly related to the question as I was following your instructions at the time and surely that would be a simple question to answer to help me locate file addresses in the future. How about it John?

 

 

Expert:  John D replied 2 years ago.

Sure after you accept

 

John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9655
Experience: Vast experience in Excel programming and business solutions
John D and other Programming Specialists are ready to help you
Expert:  John D replied 2 years ago.

Thanks

 

No personal.xls* files do not come as part of the default files when you install Excel on a new machine. They are custom files that are created by the user.

 

Now to look for a personal.xls* file that the user on a certain machine has created you can either go to the folder

C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART

 

or do a search from windows Start >Search looking for

personal.xls*

 

and making sure that you select the option to look for hidden files

 

 

 

 

 

Customer: replied 2 years ago.

The search for Personal.xls* brings up all our joint emails and the macro itself but not the address of Personal.xlsb whereas the Windows XP search function did this in that PC. Yes I already had attended to the option to look at hidden files. Not a good result for Windows 7!

But I wish to leave it be at this stage and provided you are not seeking extra money I am happy to close off now.

 

regards

 

Dean

Expert:  John D replied 2 years ago.

That's fine Dean. We will leave at that.

 

Thanks again and have a great Holiday Season

 

 

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5603
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/unvadim/2010-11-15_210218_avatar.jpg unvadim's Avatar

    unvadim

    Computer Software Engineer

    Satisfied Customers:

    1158
    Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    950
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    864
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/RA/rajivsharma086/2012-6-6_17128_displaypic.64x64.jpg Raj's Avatar

    Raj

    Computer Engg.

    Satisfied Customers:

    860
    BE CS, 4+ Experience in Programming and Database (ERP)
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    590
    11 yrs of programming (PHP, WordPress, XSL, SQL, JavaScript)