+ Reply to Thread
Results 1 to 9 of 9

Problems with my Personal.xlsb

Hybrid View

Bsethna Problems with my Personal.xlsb 10-17-2019, 11:09 AM
nigelog Re: Problems with my... 10-17-2019, 11:34 AM
Bsethna Re: Problems with my... 10-17-2019, 11:37 AM
nigelog Re: Problems with my... 10-18-2019, 04:39 AM
Bsethna Re: Problems with my... 10-18-2019, 08:50 AM
romperstomper Re: Problems with my... 10-18-2019, 06:44 AM
nigelog Re: Problems with my... 10-18-2019, 06:56 AM
romperstomper Re: Problems with my... 10-18-2019, 06:58 AM
nigelog Re: Problems with my... 10-18-2019, 07:13 AM
  1. #1
    Registered User
    Join Date
    04-17-2018
    Location
    U. S. A.
    MS-Off Ver
    2013
    Posts
    5

    Problems with my Personal.xlsb

    When I try to open any excel document I get the message denoted in the attachment. However if I click disable then my personal workbook does not show up when I start excel and I need to run some macros stored in my personal.xlsb. Any help in rectifying the problem will be appreciated.

    Best,
    Bishar

    Following up on my post. When I click "no" to disable another message pops up which is shown in attachment labeled Excel Error 2
    Attached Files Attached Files
    Last edited by Bsethna; 10-17-2019 at 11:26 AM. Reason: Additional information

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Re: Problems with my Personal.xlsb

    If any consolation I get the second read only message...I just click as to remove means deleting and reloading workbook. Hopefully an update will get rid of it.

  3. #3
    Registered User
    Join Date
    04-17-2018
    Location
    U. S. A.
    MS-Off Ver
    2013
    Posts
    5

    Re: Problems with my Personal.xlsb

    Thank you for your suggestion. However, I tried that and it does not work.

  4. #4
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Re: Problems with my Personal.xlsb

    I had a look at this and found the problem went away when I renamed the xlsb file in the XlStart folder of excel. How long it lasts remains to be seen

  5. #5
    Registered User
    Join Date
    04-17-2018
    Location
    U. S. A.
    MS-Off Ver
    2013
    Posts
    5

    Re: Problems with my Personal.xlsb

    Again, thank you for troubleshooting my problem. I will try that and let you know.

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Problems with my Personal.xlsb

    You should only get that message if you are running more than one instance of Excel manually. If you open the files from within Excel, you shouldn't have that problem.
    Everyone who confuses correlation and causation ends up dead.

  7. #7
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Re: Problems with my Personal.xlsb

    Hi Rory
    I only use one instance. This message started appearing after a windows upgrade to windows 10 a few months back.

  8. #8
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Problems with my Personal.xlsb

    Check the process list in Task Manager. I suspect you have two Excel.exe processes running. Otherwise there would be no reason for that message.

  9. #9
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Re: Problems with my Personal.xlsb

    With a single instance of excel running there was also an excel background process as well as the workbook opened. Next time the message appears I'll check what the situation is then. Ta

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using UDFs in the personal.xlsb
    By aquixano in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2016, 10:32 AM
  2. [SOLVED] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  3. Running a Personal.XLSB Macro From Within Another Personal.XLSB Macro
    By js0873 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-23-2015, 09:58 AM
  4. [SOLVED] Personal.xlsb
    By deweyirl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2015, 05:46 AM
  5. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  6. Replies: 0
    Last Post: 05-10-2012, 09:22 AM
  7. Excel 2007 : personal.xls and personal.xlsb in 2007
    By ali84pk in forum Excel General
    Replies: 0
    Last Post: 02-04-2011, 01:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1