XLSM opening onto particular cell - why?

[MadCallidus]

Hi all,

I have a largeish timesheet XLSM which contains a tab for each month of the year. Each month contains project numbers against employees. there is also some project data on the tab.

Every time I open the workbook it defaults to select a particular cell in October's tab. This cell contains an array formula as follows:
=IF(COUNTIF(DATA!$A$12:$A$224,$A$1)<14,"",INDEX(DATA!$G$12:$G$224,SMALL(IF(DATA!$A$12:$A$224=$A$1,ROW(DATA!$A$12:$A$224)-ROW(DATA!$A$12)+1,""),14)))
This is the same formula and cell format as in every other month and for several cells above and below.

As well as automatically selecting this cell on opening the file, the cell loses the squiggly brackets meaning I have to CTRL/SHILFT/ENTER each time to show the result I want.

Any ideas what is happening here?

Thanks,

Andy

 

[RoryA]

Is there any code in the Workbook_Open event in the ThisWorkbook module of the workbook?

 

[MadCallidus]

Is there any code in the Workbook_Open event in the ThisWorkbook module of the workbook?

Thanks for your reply Rory.

I have no code displaying in ThisWorkbook module.

 

[MadCallidus]

This is a shared workbook if that makes a difference. (So I have to un-share to view code).

 

[RoryA]

Is there an Autpen routine in a normal module in the workbook?

Does the same problem manifest if you have the workbook unshared?

 

[MadCallidus]

Aha!

OK, I see where the issue is here - that cell must've been selected in another open version.

However, the reason it was selected is because I had to reenter that bloody array formula... Any thoughts on that? Just one cell - always the same cell - out of 120 similar cells. I've copy and pasted the formula and the format and that doesn't seem to help.

 

[RoryA]

To be entirely honest, any time someone says "I have a weird problem with a shared workbook" my answer is always the same: don't use Shared Workbooks. They are renowned for this.