I have two workbooks stored on my server. Number One (lets call it NO OF BOXES) has excel tables in with data drawn from on ODBC data export.
I have them summarised this to give me total number of boxes for todays orders to 5 different sales areas.
I then have another line in the summary table that draws data (showing what capaciity I have on vehicles delivering to each area I have available, from a seperate workbook, also on my server.. This second workbook (lets call it VEHICLE CAPACITY) is updated through the day and I want my NO OF BOXES spreadsheet to update automatically from the changed VEHICLE CAPACITY spreadsheet. The data is from from VEHICLE CAPACITY spreadsheet by way of VLOOKUP forumlas. The NO OF BOXES
sheet is open on a thinclient from a terminal server session and displays the reults on a wall mounted dashboard. The VEHICLE CAPACITY spreadsheet I update manually from my PC.

Any ideas how I can get excel formulas to recalculate automatically and update linked valued automatically when they are open in different sessions on terminal servers?
Thanks