Access sometimes opens linked Excel spreadsheet in Excel randomly?

[davemarco]

Hi all,

Seeing some strange behavior here. I have a database front end with an Excel spreadsheet as a linked table. On occasion, when one of my users either starts up the database, or attempts to run a query that pulls from that linked table, it will automatically open up the linked spreadsheet in Excel. This only happens if they already have Excel open.

Does anyone happen to know why this behavior occurs? I tried to google "Linked Excel Tables randomly open in Excel" but found nothing.

 

[Ranman256]

I have gotten this occasionally, but found it harmless and never solved it.
But is was odd.
you could ,after the query opens, call Access back to the front window:
docmd.Maximize

 

[davemarco]

Hi Ranman, thanks for the reply. The issue isn't so much that the spreadsheet is popping to the front. The major problem is that occasionally when one of my users open the database, one of the linked spreadsheets will pop open with it in full WRITE mode. As a result, whenever any of my other users attempt to use the database, they get an error mentioning that the linked spreadsheet is open by another user.

If it helps, it only seems to happen if they already have Excel open, but not every time (I am unable to reproduce it).

 

[Ranman256]

I too have seen it , but never figured out why/how.