SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Many personal.xlsb open

(8 posts)
  • Started 1 year ago by 6card
  • Latest reply from moreeg
  • Topic Viewed 795 times

6card
6card
Posts: 357

Since my OS reload I see a new personal.xlsb for every excel workbook I open. At time I may have 5 or so open. I pain the shut all down.

Is this normal behavior? How to fix?

Sixcard

Posted 1 year ago
Top
 
Xhi
Xhi
Posts: 6298

Sounds normal to me. "If it ain't broke, don't fix it"

Posted 1 year ago
Top
 
moreeg
moreeg
Posts: 842

Are you sure it's only since the OS reload? Feels like deja vu to me ...

Xhi aka Mr. Consistent

Posted 1 year ago
Top
 
6card
6card
Posts: 357

@moreeg Not 100% sure if only since new OS, but I just don't remember so many. Many autosaved, many locked and what have you. Truly a pain, even "if it ain't broke".

six

Posted 1 year ago
Top
 
6card
6card
Posts: 357

OK, let me ask in a different way ...

Is it normal for a "personal.xlsb" to open with each xxxx.xls even if one is already open? e.g., 4 xls open = 4 xlsb open?

Any way to change that?

I have been an MS Excel user for many years and this does not seem normal.

six

Posted 1 year ago
Top
 
moreeg
moreeg
Posts: 842

I've played around with this a bit and found that with my set-up: (which would be fairly typical. I believe, because I just reinstalled the OS back to the factory settings)

normally it would be impossible to have more than one personal.xlsb open at the same time UNLESS you've defined it as a Shared workbook - have you done that?

If you open different workbooks in the same instance of excel it will only open the single instance of Personal.xlsb. But if you open several workbooks in different instances of excel then it will try to open the Personal.xlsb once for each instance.

When you have separate tasks in the scheduler to open different workbooks it will open each workbook in a separate instance of excel hence the multiple instances of personal.xlsb.

One way around this is to have a single task that opens a blank worksheet that has this macro in the ThisWorkbook module;

Private Sub Workbook_Open()
Workbooks.Open ("C:\users\USERNAME\Documents\FILE1.xlsx")
Workbooks.Open ("C:\users\USERNAME\Documents\FILE2.xlsx")
Workbooks.Open ("C:\users\USERNAME\Documents\FILE3.xlsx")
End Sub

This will open all the workbooks in the same instance of XL and hence only one copy of Personal.xlsb

Is this a viable solution for you?

Posted 1 year ago
Top
 
6card
6card
Posts: 357

@moregg

Until I googled it I knew not of a Shared Workbook. No, I don’t share workbooks.

However, I do have a number of workbooks that open via the task scheduler. That may be the key. But why would the TS opening workbooks be different from me opening them?

I am not clear on what is an “instance” of Excel. Seems like every time I open a new Excel file (workbook??) it would be a new instance????

I will watch for TS workbooks opening on top of one another to see if this is what is happening.

Posted 1 year ago
Top
 
moreeg
moreeg
Posts: 842

If you have several workbooks open in the same instance of excel you can switch among them via View/Switch Windows where you'll see a list of all the workbooks you've opened. What you can't do easily is view them in separate windows. That's why many prefer to open workbooks in separate instances of excel. One way to do this is to double click on excel.exe and open a workbook and do the same for every workbook. Now if you go to View/Switch Windows you'll only see the current workbook listed. This is what happens when I open several workbooks vie the scheduler.

When you check your files tomorrow check to see if you can see them all listed in View/Switch Windows.

Posted 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!