Another Update Links Question

[warren.rust]

Hey, new to the forum and an Excel noob using Excel 2007. I've searched and don't see a thread that directly addresses my question, so pardon me if I've missed it, please.

I have a source workbook (let's call it 'source.xlsx') which is overwritten at the top and bottom of every hour from a database extract. This data is required by the users 24/7, but keeping this workbook open obviously causes problems with the periodic overwrite. 'source.xlsx' has 4 tabs with ~3500 active cells.

I've created another workbook (call it 'links.xlsx') which has just simple links to the cells in 'source.xlsx' in order to have a workbook with the needed data open but allow the source workbook to remain closed to permit it to be written to.

I was hoping that the always open 'links.xlsx' would automatically update the cells when the cells in the always closed 'source.xlsx' was written to, but that is not happening. Also F9 and Data Tab>Refresh All do not cause the links to update. Data Tab>Edit Links>Update Values does work, but like I said I was hoping for automatic.

Both workbooks are in the same directory, same folder. Excel Options>Formulas>Workbook Calculations is set to Automatic. I've selected that directory/folder as a trusted location in Trust Center settings and enabled automatic update for Workbook links.

Am I missing something, or is this functionality not supported?

Thanks for your help.
- wr

 

[Kele]

I have this problem as well did you ever get any help?

 

[warren.rust]

No. I am 'stuck' manually refreshing the "links.xlsx" workbook as needed. I don't know if there is a VBA trick which would work, but even if so I'm not sufficiently sophisticated to write it.
- wr