Workbook links causing linked workbook to open, but remain hidden

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

Hi Rob
To be able to diagnose the problem we would need to see the workbook. One thing to check is to make sure that you have no Worksheets that are set to "Very Hidden". If you do then those sheets may have code attached to them. Enter ALT+F11 to display the code module.
Then click on each Sheet name on the left hand side and make sure that the last property in the Properties box is not set to xlVeryHidden. If it is change it to xlVisible then check if there is any code behind the worksheet.
Hope this helps.
Tony

Hi Tony,

Many thanks for the suggestion. I checked all the sheets and none of them were very hidden.

However, I HAVE solved the problem.

Where most of the cells were linking to a cell in another workbook in the normal manner i.e. ="File path\[workbook name]sheet name"!$E$1930
There were are few cells where instead it had =Excel.Sheet.8|!"full file path including server and workbook name"!sheet name!R1934C5

Once I changed those few cells to match the rest then it no longer opens and hides the linked workbook. Problem solved!

Thanks for the feedback Rob.