Excel 2007 : Referening from one workbook to another formula.

I apologize in advance for the typo's.

Here's an example of what i have and what i am trying to do. For reference, i have attached the file with 2 sheets referencing each other in the same workbook and a file with each source and display files.

I don't expect anyone to do any the work, i just need to know how to edit the following formula to make it see the exact cell but just in another workbook.

I have the following formula in place to reference from one sheet to another in the same workbook:

=IF('Inside Turnover'!$E$45<>"",'Inside Turnover'!$D$45&" "&'Inside Turnover'!$E$45,IF('Inside Turnover'!$D$45="","",'Inside Turnover'!$D$45))

BUT i want to do this using IST1 as the source where someone can do input and update while IST2 is displaying the changes on a monitor in another room.

The problem i am having is this.

The above formula is doing the following:
An entry is made in D45 on the Inside turnover sheet. Another entry is made if needed into E45 that turns the cell fill to yellow in D45. If an entry is made in E45, it turns the text in D45 Blue. E45 and D45 are never used at the same time. I also have conditioning formulas making the color changes.
Attachment 145242Attachment 145243Attachment 145244

If you look at the inside turnover NEW. that's what i want to do but in 2 different files as described above but i am having trouble gettingthe different files to act the same as the original file does.


When opening the files. i only want the columns D. E. F. to have the formulas to have an entry on Inside Turnover tab of the Inside Turnover(NEW) file which i have also saved as Inside Turnover1. I'm sure it will be obvious. Yeah right. haha
TMI? or not enough?

the sheets that you provided are password protected, but i think what you want to do is something like this; change your references to include the path and file name for example a reference to A1 on another sheet would be:

='C:\Fourms\[Book1.xlsx]Sheet1'!A1

on another note, the changes will not reflect in the second workbook unless it is 'recalculated'

you could do this with a macro that automaticaly recalculates the sheet every x seconds, or by pressing F9 to maunaly recalculate.

try using this code in your workbook

Please Login or Register  to view this content.

this is a bit more specific, try this, sorry for all the attempts, i cant test this on my own system as i only have one pc

Please Login or Register  to view this content.

note: you might need to update the file location, and it is set for 30 second refresh, you could reduce that.

you can put the code in the workbook module as bellow and it will automaticaly run when the workbook loads. if for some reason you need to intrupt it just press Esc.

Please Login or Register  to view this content.

try this out, if not, im not really sure on that one.

Please Login or Register  to view this content.