The file is hidden and this has only occured since I got rid of my previous problem of having a Peronal.xls:2 worksheet. Aaron Awesome! Reply Brett says: October 10, 2014 at 8:19 PM Thank you. Frank says: August 11, 2014 at 7:01 pm Hello, I currently using Excel 2010 and when i record a Macro and the drop doesn't list PERSONAL WORKBOOK to select how do
I want to save a spreadsheet as a template with its own macros to expedite work and not have it interact with any other spreadsheet but the one I create for The Personal file is .xls. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Just name it correctly and store it in the correct location and Excel will read it on launch. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/personalxlsb-opens-when-opening-a-new-file/802a3269-fdb8-48b9-b3a8-c26a4235df05
Lol!I guess it is one of those situations that are obvious only after you know the answer.Thanks for the accept. Pingback: Fun with Google Analytics | wheatblog rob blythe says: July 5, 2012 at 3:55 am Most helpful, Thanks Carolyn says: July 6, 2012 at 1:49 pm Thank you so much! Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4.
Everything I found out there said that you simply need to change the option for Save-As to be the 2007 format. All contents Copyright 1998-2017 by MrExcel Consulting. This will stop the security warning on entry. Hope that helps!
Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? Why use convolutional NNs for a visual inspection task over classic CV template matching? Thank you, thank you, thank you! http://www.excelforum.com/showthread.php?t=712761 Linda I just recently got a new computer and now have excel 2010, the only one in the office.
Susan Snyder I am also have the same issue. Justin Click the Office Button in an Excel worksheet. Richard Schollar Microsoft MVP - Excel Register To Reply 01-05-2010,08:04 AM #7 JoProvis View Profile View Forum Posts Registered User Join Date 09-03-2009 Location London, England MS-Off Ver Excel 2003 Posts The best advice for your readers (like me) is explained on Ron de Bruin's website: http://www.rondebruin.nl/personal.htm 1) Open excel 2) Hit alt-F11 to get to the VBE 3) Hit ctrl-g to
Chris Marisa Thank you so much for this tip. He is president of Sharon Parq Associates, a computer and publishing services company. It always opens in the compatibility mode so I am also loosing half my functions. Any help would be appreicated.
Hot Network Questions Do Dragonborn come from eggs? Of course there is a way to do it properly (as others have said above). Shah says: September 12, 2016 at 3:49 am Slight mistake for Windows 7 path Correct path for user "CK" is C:\Users\ck\AppData\Roaming\Microsoft\Excel\XLSTART you have written "C:\Users\AppData …. Excel by default will look in this location (based on where you installed Excel) for the default workbook it uses when starting up.
This may solve the problem, but it may not. (You'll know the next time you start Excel.) The other possibility is that, somehow, the location of where Excel expects Personal.xls to This of course comes after completely blowing away my profile and recreating it on my laptop… Gehan Thank you very much for this useful tip which worked for me. Conclusion I think that for most users, this will be sufficient. It's actually the 13th version of Office, but Microsoft saw fit to skip naming it Office 13, due, one suspects to superstition.
PC died and new one has 2010. Why make things difficult? It would be great if I could just get rid if it altogether and start again regards Jo Register To Reply 01-05-2010,07:13 AM #5 JoProvis View Profile View Forum Posts Registered
This was a big help. Thats all. My name is Richard Marskell and I'm the co-founder of LittleBigComputers. Suneet Arora says: May 16, 2013 at 6:44 am I have got XLSTART folder at two paths on my PC (m using Excel 2010): 1) C:\Documents and Settings\suneetaro\Application Data\Microsoft\Excel\XLSTART 2) C:\Program
oliver awesome. I had made changes to excel 2010 to have each file open in separate window. Please note that if you want to edit the file again, to add another macro for example, you'll have to un-check the read-only box, update the file and then recheck it. Thanks for your detective work..