Hi everyone,

I've been asked to help fix a spreadsheet that's causing a few problems here at work and it's doing something I've not come across before...

There are lots of link from it to another spreadsheet which contains information about the relevant projects. But what it seems to be doing is actually opening the spreadsheet that it's linking to and then hiding it (this is causing problems because people aren't aware that they have it open and it's preventing the people who need to from being able to update it).

I've looked through all the sheets in the VBA editor and can't see any sign of any macros.

Has anyone come across Excel behaving like this before when information is being linked from another workbook?

Many thanks in advance,

Rob

P.S. We're using Excel 2010