Excel Book1 opens spontaneously

Question

Excel Book1 opens spontaneously

billroberts 36

I have Microsoft365, Office 2021, 64xbit.
I placed file (MASTER09.xlsm), folder (Metadata15) and folder (MS15XLS.DLL) on my OneDrive account. Metadata15 and MS15XLS.DLL must be on your C drive in to run MASTER09.xlsm.
MASTER09 runs up to 16 stock symbols and generates a spreadsheet for each symbol. After I have run the program, I select “Save” and the file closes. About 6 seconds later, Excel Book1 opens. How do I stop Excel from opening? Bill Roberts
ps I'm not sure how to share my files with anyone. I just put them on my OneDrive.

0 comments

10 answers

Your answer

Answer 1

billroberts 36

That was a waste of time. I followed your instructions through your recommended web site. and I finally requested the microsft empoyee to take over my computer to demo the problem. He texted that he would have to transfer me to another microsoft team for remote access. I waited 25 minutes, with no reponse. Then I shut down. I would appreciate referral to any microsft team that can remotely access my computer so I can show them the problem.

Ceasar Chen_MSFT 4,486 Reputation points

2022-06-08T01:29:12.88+00:00

It is recommended that you wait for a response from the Microsoft Remote Telephony team, which may take some time.

Answer 2

billroberts 36

I do not understand what "open a ticket" means. Please give me the procedure or a link to information. Thank you. Bill Roberts.

0 comments

Answer 3

billroberts 36

The file MASTER09 runs 10 macros, managed by the master/macro. I have written all the code, so I am familiar with it.
Aplication.OnTime is never used in any macro.
I don't know if you can run the macro from OneDrive, but if not, if you will comunicate directly to me , I will send you the folders (metastock15 and MS15XLS.dll) and a copy of file MASTER09, then you may run the file on your computer. I know the issue occurs on at least one other computer. Bill Roberts

Ceasar Chen_MSFT 4,486 Reputation points

2022-06-03T01:39:23.477+00:00

This is a public forum, and we can only reply to you on the forum, not by other means. You have your email in your reply, this is your private information, I will delete it for safety.

Answer 4

billroberts 36

I loaded MASTER09 in safe mode, ran 4 symbols, and Excel Book1 still opens a few seconds after I close MASTER09.xlsm
I went through the modify/online repair/reload process for Microsoft365, and Excel Book1 still opens after I close MASTER09.

Ceasar Chen_MSFT 4,486 Reputation points

2022-06-02T05:43:12.78+00:00

Does your Excel file have macros set up? Is Application.OnTime used in the macro?

Answer 5

Ceasar Chen_MSFT 4,486

Hi, @billroberts
Does this happen to all Excel files? Is there a pop-up prompt when Excel Book1 is opened?
You can also try saving the file locally instead of in OneDrive. Usually, you can try to repair Office in Control Panel first.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

billroberts 36 Reputation points

2022-05-30T17:50:58.32+00:00
It happens with all Excel files that "step" through a series of stock symbols, although it doesn't seem to happen as much if I only run 1 or 2 symbols. It does not happen with other Excel files. The MASTER09 program ran OK with Office 2016, although I have made a bunch of changes to the program since then.

There is no pop up prompt. Excel Book1 just opens after about 6 seconds.

I do save the file locally. I have not (historically) used OneDrive. "AutoSave" is off in Excel.

I have run the Office "cleanup" programs, as well as uninstall/reinstall Office.

I have experimented with the "set nnnnn=nothing" command because I think it might be related to memory overload, but that did not seem to change anything.

Not sure how to "repair Office in Control Panel". I have carefully looked at File/Options. Don't see anything.

I have some knowledge of Visual Basic, but I get lost on the "on Error" and ""nnn=nothing" commands. I still wonder if it is a memory overload issue, but I can't conceive how that would trigger OfficeBook1 to open.

Thanks very much for the help. Bill Roberts
Ceasar Chen_MSFT 4,486 Reputation points

2022-05-31T07:32:27.323+00:00

Hi, @billroberts
You can try to start Excel in safe mode, hold down Ctrl, double-click the Excel file, and select OK in the pop-up dialog box.After closing it, see if the problem still occurs.

Find the Office program in System Settings - Apps and Features and click Modify.

Share via

Excel Book1 opens spontaneously

10 answers

Your answer