Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2016, 06:06 AM
WRowan WRowan is offline Personal wkbook does not load Windows XP Personal wkbook does not load Office 2010 32bit
Novice
Personal wkbook does not load
 
Join Date: Jun 2012
Posts: 4
WRowan is on a distinguished road
Default Personal wkbook does not load

Windows 7, MO 2013



My Personal.xlsb wkbook (PWB) does not load when I start Excel or open another Excel file, making the macros in the PWB unavailable. Here is what I have tried:

1. View>Unhide is grayed out

2. File>Options>Add-Ins>Disabled Items>Go shows nothing disabled

3. Other Excel Options:
  • Trusted Locations: "Disable all Trusted Locations" is NOT checked.
  • Trusted Documents: "Disable Trusted Documents" is NOT checked.
  • Add-ins: No checkboxes are checked.
  • Macro Settings: “Disable all macros with notification” is checked. "Trust access to the VBA project object model" is checked.

4. File>Options>Trust Center>Trusted Center Settings>Trusted Locations>Add new location. I tried adding the location of the Personal.xlsb file, but I get a message the location “has already been added.”

5. Lastly, I tried the following:
C>Users>me>AppData>Roaming>Microsoft>Excel>XLSTART >deleted the Personal workbook and created a new file with the same name, recorded a macro and closed. I then opened a new workbook but the macro in Personal is not available, and View>Unhide is grayed out. If I then open the Personal workbook using File>Open, the macro in the Personal wkbook becomes available in any other open workbook. But the Personal workbook will still not load on its own “behind the scenes” when initially opening another file or the program.

Completely out of ideas. Help!?

Last edited by WRowan; 06-22-2016 at 08:48 AM. Reason: spelling correction
Reply With Quote
Reply

Tags
does not load, personal workbook

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Personal wkbook does not load excel does not load mangoa Excel 2 01-11-2014 07:55 AM
Outlook Mac 2011 will not load kevins29 Outlook 0 04-05-2012 09:40 AM
Personal wkbook does not load OUtlook does not load outlookuser Outlook 2 11-09-2011 09:16 AM
Personal wkbook does not load Slow load? markg2 Word 1 03-15-2011 07:10 AM
PowerPoint Add-in fails to load in start up but loads successfully if load manually f shahbazlibra PowerPoint 0 11-30-2010 08:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft