Excel opening workbook in another instance

tomleitch

Board Regular
Joined
Jan 3, 2012
Messages
185
Hi all,

I have some multiple workbooks that I have saved on a sharepoint site that have macros to open other workbooks on that site and pull data out of them

This all works fine, except sometimes when I open the other workbooks from the sharepoint site. excel seems to open the workbook in another instance of excel.

This results in me not being able to re-open the workbook when my macro calls for it - but also stops my code from working as it can't see that the other workbook is open.


Any help would be appreciated.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,661
Mmm haven't seen that before. Is it really another instance, or is it perhaps that Excel opened the file in 'protected' mode, waiting for you to press the edit button?
 

tomleitch

Board Regular
Joined
Jan 3, 2012
Messages
185
Yeah it's another instance.

It seems to only do it when I store it on microsoft teams... and not when using sharepoint proper - so I guess it's a glitch in MS teams
 

Watch MrExcel Video

Forum statistics

Threads
1,099,789
Messages
5,470,791
Members
406,724
Latest member
BruceLee Nguyen

This Week's Hot Topics

Top