Excel Opens Multiple Other Workbooks on Startup

P

paulturner

Anyone else having this issue? Over time of repeated use Excel starts
opening workbooks that, yes were being worked on recently but were
closed before Excel was quit. The only way I can get it to stop
opening the workbooks is to trash the preferences. Anyone else getting
this? Anyone have a better fix? Its hard to tell my CFO and CEO that
this is a bug and to live with it.

-P
 
K

Kristina Conceicao

Anyone else having this issue? Over time of repeated use Excel starts
opening workbooks that, yes were being worked on recently but were
closed before Excel was quit. The only way I can get it to stop
opening the workbooks is to trash the preferences. Anyone else getting
this? Anyone have a better fix? Its hard to tell my CFO and CEO that
this is a bug and to live with it.

-P

Hi Paul,

One of my users is having the same problem. She's running Excel 2004
with the 11.3.3 patch applied, Mac OS 10.3.9. This is not a new
computer, new account or new installation of Office. She faithfully
closes down Excel at the end of each day. When she launches it the next
morning, regardless of whether she's launching via the Dock or by
double-clicking on an Excel document, it sometimes opens more files than
she's asking it to. I have checked her Startup folders to verify that
the files are not there, and have verified that she doesn't have an
alternate startup location specified. At this point I'm not sure what
to do. Where is the Preference file that you're trashing? Does anyone
else have any suggestions on how to troubleshoot this?

Thanks,

Kristina
 
P

paulturner

Yeah - same thing. These guys are getting a lot of files back and
forth from PCs so I wonder if this has anything to do with it.

The preference is in Macintosh
HD>Users>username>Library>Preferences>Microsoft and its called
"com.microsoft.Excel.prefs.plist"

It doesn't fix it forever but it resets it back to where you don't have
the workbooks opening up all the time. It is also a good fix for when
the formula bar disappears and you can't get it back.

-P
 
J

JE McGimpsey

Anyone else having this issue? Over time of repeated use Excel starts
opening workbooks that, yes were being worked on recently but were
closed before Excel was quit. The only way I can get it to stop
opening the workbooks is to trash the preferences. Anyone else getting
this? Anyone have a better fix? Its hard to tell my CFO and CEO that
this is a bug and to live with it.

If the files are not in the Startup folder (or alternate startup folder
specified in Preferences/General), try opening XL with the Shift key
down, then closing it. This should get rid of any AutoRecover documents.
 
C

CyberTaz

Another thought - although unlikely - they aren't perchance opening a saved
*Workspace* are they?

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
K

Kristina Conceicao

My user tried JE's suggestion yesterday. When she reopened Excel the
second time, everything was fine. However, when she launched it today,
the problem resurfaced.

I have not trashed the plist that Paul mentioned, as that only seems to
be a temporary fix and I'm not sure what other info is stored in there.

I also confirmed that she's not dealing with Workspaces, as per Bob's
suggestion.

Any other ideas would be greatly appreciated!

Kristina
 
J

JE McGimpsey

Kristina Conceicao said:
My user tried JE's suggestion yesterday. When she reopened Excel the
second time, everything was fine. However, when she launched it today,
the problem resurfaced.

I have not trashed the plist that Paul mentioned, as that only seems to
be a temporary fix and I'm not sure what other info is stored in there.

I also confirmed that she's not dealing with Workspaces, as per Bob's
suggestion.

If starting with the shift key down worked temporarily, but the problem
came back, I've got to wonder if XL is routinely shutting down
abnormally.

Is she getting any OS messages about XL having to quit?
 
K

Kristina Conceicao

JE said:
If starting with the shift key down worked temporarily, but the problem
came back, I've got to wonder if XL is routinely shutting down
abnormally.

Is she getting any OS messages about XL having to quit?

For the most part, it's shutting down normally when she chooses file:
quit. She does get the OS's quitting message sometimes, and I do know
that files will reopen if you select the recover option in the crash
window. I've made sure that she's not selecting that option. She can
reopen Excel after a crash without files opening. But at some later
time, after shutting down gracefully, the problem will resurface.

I can't say for sure that the shift key actually did anything, since she
doesn't get the problem every time she opens Excel. For some reason, it
seems to happen when she launches it each morning. Her machine stays on
overnight, and she stays logged into her mac account. We have some
backing up going on across the network, but nothing has changed with
that recently.

I've read posts about people having other types of problems with Word
and Excel and they end up migrating to a new mac account to solve the
problem. Do you think that's worth a shot here? Or should I try
trashing the plist that Paul mentioned?

Thank you for your help!

Kristina
 
H

Hilena Hailu [MSFT]

Hi Paul and Kristina,



Thank you for reporting this issue.



I'm trying to narrow down the problem, but I need your help. First, let me
see if I understand what's happening. You launch Excel, open some files and
save them after making changes, then close the application gracefully. At a
later time, when you launch Excel again, the files you worked on previously
open even though you did nothing to open them. Is that the essence of the
issue? If so, where are you saving the files during the first session?
Second, you mentioned that after SHIFT+launch of the application, the
problem went away and then came back. What set of actions caused did you
take before the problem resurfaced? Third, what is contained in these files
(e.g. objects with external cell references, VB code, etc)? Fourth, are you
seeing this behavior with other Office:mac applications as well?



Kristina -- you mentioned that your user gets "the OS's quitting message
sometimes." Although that's probably another issue, I am interested in
hearing about it. Feel free to post another topic on this newsgroup or
continue the conversation in this thread.



I look forward to your reply.



Regards,

Hilena Hailu
Excel:mac

Macintosh Business Unit
Microsoft Corp.
 
H

Hilena Hailu [MSFT]

Paul and Kristina,

Questions about the files that open when you launch Excel. Would the
titlebar on the workbook window happen to say "[Recovered]"?

Regards,
Hilena Hailu
Excel:mac
Macintosh Business Unit
Microsoft Corp.
 
K

Kristina Conceicao

Hi Hilena,

Thanks for picking up on this issue. You have accurately described the
problem. The user opens files, edits and saves them, and closes Excel
gracefully. The next time she launches Excel, the files open, seemingly
by themselves. The files are usually stored on servers. The titlebar
does not say "[Recovered]"; this does not seem to be the result of
allowing Excel to relaunch and reopen documents after a crash.

The user is in the habit of launching Excel each morning, working
throughout the day, and closing it at the end of the day. When I had
her SHIFT+launch the app, she did so and then reopened the app. No
files opened. She continued using Excel for the rest of the day and
closed it gracefully. When she launched it the next day, files opened.

The files are usually tables of data. They may contain formulas with
external cell references. I don't believe that they contain any VB code.

I don't have details about the crashes. I'll ask her to send me the
crash log the next time it happens and will start another thread at that
time.

As for other Office apps, funny you should ask. She also uses Word
every day, and yesterday, for the first time, she saw this behavior with
Word. She launched it and previously edited docs opened seemingly by
themselves.

Thank you again for your help. I will be out of town until mid
February, so please do not take any lack of response on my part for lack
of interest :) I will be checking back when I return.

Kristina

Hilena Hailu [MSFT] wrote:
Questions about the files that open when you launch Excel. Would the
titlebar on the workbook window happen to say "[Recovered]"?
 
H

Hilena Hailu [MSFT]

Kristina/Paul

We have been unable to repro the issue, but we are tracking it for
investigation. Thank you taking the time to reporting it. If you see other
issues, please do post them here as we are paying attention!

Regards,
Hilena Hailu
Excel:mac
Macintosh Business Unit
Microsoft Corp.

--------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.

Kristina Conceicao said:
Hi Hilena,

Thanks for picking up on this issue. You have accurately described the
problem. The user opens files, edits and saves them, and closes Excel
gracefully. The next time she launches Excel, the files open, seemingly
by themselves. The files are usually stored on servers. The titlebar
does not say "[Recovered]"; this does not seem to be the result of
allowing Excel to relaunch and reopen documents after a crash.

The user is in the habit of launching Excel each morning, working
throughout the day, and closing it at the end of the day. When I had her
SHIFT+launch the app, she did so and then reopened the app. No files
opened. She continued using Excel for the rest of the day and closed it
gracefully. When she launched it the next day, files opened.

The files are usually tables of data. They may contain formulas with
external cell references. I don't believe that they contain any VB code.

I don't have details about the crashes. I'll ask her to send me the crash
log the next time it happens and will start another thread at that time.

As for other Office apps, funny you should ask. She also uses Word every
day, and yesterday, for the first time, she saw this behavior with Word.
She launched it and previously edited docs opened seemingly by themselves.

Thank you again for your help. I will be out of town until mid February,
so please do not take any lack of response on my part for lack of interest
:) I will be checking back when I return.

Kristina

Hilena Hailu [MSFT] wrote:
Questions about the files that open when you launch Excel. Would the
titlebar on the workbook window happen to say "[Recovered]"?
I'm trying to narrow down the problem, but I need your help. First, let
me see if I understand what's happening. You launch Excel, open some
files and save them after making changes, then close the application
gracefully. At a later time, when you launch Excel again, the files you
worked on previously open even though you did nothing to open them. Is
that the essence of the issue? If so, where are you saving the files
during the first session? Second, you mentioned that after SHIFT+launch
of the application, the problem went away and then came back. What set of
actions caused did you take before the problem resurfaced? Third, what is
contained in these files (e.g. objects with external cell references, VB
code, etc)? Fourth, are you seeing this behavior with other Office:mac
applications as well?



Kristina -- you mentioned that your user gets "the OS's quitting message
sometimes." Although that's probably another issue, I am interested in
hearing about it. Feel free to post another topic on this newsgroup or
continue the conversation in this thread.



I look forward to your reply.



Regards,

Hilena Hailu
Excel:mac

Macintosh Business Unit
Microsoft Corp.
 
K

Kristina Conceicao

Thank you for your response!

Kristina

Kristina/Paul

We have been unable to repro the issue, but we are tracking it for
investigation. Thank you taking the time to reporting it. If you see other
issues, please do post them here as we are paying attention!

Regards,
Hilena Hailu
Excel:mac
Macintosh Business Unit
Microsoft Corp.

--------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.

Kristina Conceicao said:
Hi Hilena,

Thanks for picking up on this issue. You have accurately described the
problem. The user opens files, edits and saves them, and closes Excel
gracefully. The next time she launches Excel, the files open, seemingly
by themselves. The files are usually stored on servers. The titlebar
does not say "[Recovered]"; this does not seem to be the result of
allowing Excel to relaunch and reopen documents after a crash.

The user is in the habit of launching Excel each morning, working
throughout the day, and closing it at the end of the day. When I had her
SHIFT+launch the app, she did so and then reopened the app. No files
opened. She continued using Excel for the rest of the day and closed it
gracefully. When she launched it the next day, files opened.

The files are usually tables of data. They may contain formulas with
external cell references. I don't believe that they contain any VB code.

I don't have details about the crashes. I'll ask her to send me the crash
log the next time it happens and will start another thread at that time.

As for other Office apps, funny you should ask. She also uses Word every
day, and yesterday, for the first time, she saw this behavior with Word.
She launched it and previously edited docs opened seemingly by themselves.

Thank you again for your help. I will be out of town until mid February,
so please do not take any lack of response on my part for lack of interest
:) I will be checking back when I return.

Kristina

Hilena Hailu [MSFT] wrote:
Questions about the files that open when you launch Excel. Would the
titlebar on the workbook window happen to say "[Recovered]"?
I'm trying to narrow down the problem, but I need your help. First, let
me see if I understand what's happening. You launch Excel, open some
files and save them after making changes, then close the application
gracefully. At a later time, when you launch Excel again, the files you
worked on previously open even though you did nothing to open them. Is
that the essence of the issue? If so, where are you saving the files
during the first session? Second, you mentioned that after SHIFT+launch
of the application, the problem went away and then came back. What set of
actions caused did you take before the problem resurfaced? Third, what is
contained in these files (e.g. objects with external cell references, VB
code, etc)? Fourth, are you seeing this behavior with other Office:mac
applications as well?



Kristina -- you mentioned that your user gets "the OS's quitting message
sometimes." Although that's probably another issue, I am interested in
hearing about it. Feel free to post another topic on this newsgroup or
continue the conversation in this thread.



I look forward to your reply.



Regards,

Hilena Hailu
Excel:mac

Macintosh Business Unit
Microsoft Corp.

--------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no
rights.



JE McGimpsey wrote:
My user tried JE's suggestion yesterday. When she reopened Excel the
second time, everything was fine. However, when she launched it
today, the problem resurfaced.

I have not trashed the plist that Paul mentioned, as that only seems
to be a temporary fix and I'm not sure what other info is stored in
there.

I also confirmed that she's not dealing with Workspaces, as per Bob's
suggestion.
If starting with the shift key down worked temporarily, but the problem
came back, I've got to wonder if XL is routinely shutting down
abnormally.

Is she getting any OS messages about XL having to quit?
For the most part, it's shutting down normally when she chooses file:
quit. She does get the OS's quitting message sometimes, and I do know
that files will reopen if you select the recover option in the crash
window. I've made sure that she's not selecting that option. She can
reopen Excel after a crash without files opening. But at some later
time, after shutting down gracefully, the problem will resurface.

I can't say for sure that the shift key actually did anything, since she
doesn't get the problem every time she opens Excel. For some reason, it
seems to happen when she launches it each morning. Her machine stays on
overnight, and she stays logged into her mac account. We have some
backing up going on across the network, but nothing has changed with
that recently.

I've read posts about people having other types of problems with Word
and Excel and they end up migrating to a new mac account to solve the
problem. Do you think that's worth a shot here? Or should I try
trashing the plist that Paul mentioned?

Thank you for your help!

Kristina
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top