G
garygoodguy
Hi,
I have build a forecasting model in Excel. Long story short - we have
folder that contains several workbooks. There is a mapping workbook tha
houses all the data (50MB). We also have lowest level workbooks that
when opened, also open the mapping workbook hidden in the backgroun
(read-only), so that the figures update and users can input.
Each of these lowest level work books then roll up to a consolidatio
workbook (that also opens the mapping workbook hidden in th
background), but figures are direct links to the lower level workbooks
i.e. SUM(S:\Shared folder\forecast folder\lower level 1, S:\Share
folder\forecast folder\lower level 2, S:\Shared folder\forecas
folder\lower level 3, etc). Some of these consolidation workbooks lin
to 4 lower level workbooks, while others link to more.
Now, this has worked fine previously (last month), however this mont
something strange has happened. When we open a consolidation workbook w
are getting inflated numbers. I got a colleague to open it on their p
(obviously read-only) and they had completely different numbers to me?
NB: one of the workbooks was correct and the other was wrong.
So I closed and my colleague opened it and got strange numbers again
Then they closed and I tried and the numbers were correct again.
Does anyone know what's going on here?
On the consolidation workbooks I have some VBA in workbookopen tha
updates the linsk to the lower level workbooks and recalculates o
workbook open. Even after opening, we can F9 and still get the incorrec
figures.
I'm thinking possible it's because more people are trying to acces
their lower level workbooks (there are 47 lower level workbooks) an
subsequently everyone is opening up the mapping file in the backgroun
all at the same time. This was not the case last month. But then, th
figures for the consolidated workbooks are direct filepath links to th
lower level workbooks, bot calculated from the mapping file.
If anyone can offer any guidance and/or explanation I would be greatl
appreciative. Also, please advise if you require more detail.
Thanks in advance.And sorry for the novel
I have build a forecasting model in Excel. Long story short - we have
folder that contains several workbooks. There is a mapping workbook tha
houses all the data (50MB). We also have lowest level workbooks that
when opened, also open the mapping workbook hidden in the backgroun
(read-only), so that the figures update and users can input.
Each of these lowest level work books then roll up to a consolidatio
workbook (that also opens the mapping workbook hidden in th
background), but figures are direct links to the lower level workbooks
i.e. SUM(S:\Shared folder\forecast folder\lower level 1, S:\Share
folder\forecast folder\lower level 2, S:\Shared folder\forecas
folder\lower level 3, etc). Some of these consolidation workbooks lin
to 4 lower level workbooks, while others link to more.
Now, this has worked fine previously (last month), however this mont
something strange has happened. When we open a consolidation workbook w
are getting inflated numbers. I got a colleague to open it on their p
(obviously read-only) and they had completely different numbers to me?
NB: one of the workbooks was correct and the other was wrong.
So I closed and my colleague opened it and got strange numbers again
Then they closed and I tried and the numbers were correct again.
Does anyone know what's going on here?
On the consolidation workbooks I have some VBA in workbookopen tha
updates the linsk to the lower level workbooks and recalculates o
workbook open. Even after opening, we can F9 and still get the incorrec
figures.
I'm thinking possible it's because more people are trying to acces
their lower level workbooks (there are 47 lower level workbooks) an
subsequently everyone is opening up the mapping file in the backgroun
all at the same time. This was not the case last month. But then, th
figures for the consolidated workbooks are direct filepath links to th
lower level workbooks, bot calculated from the mapping file.
If anyone can offer any guidance and/or explanation I would be greatl
appreciative. Also, please advise if you require more detail.
Thanks in advance.And sorry for the novel