I have an Excel workbook that contains a list of part numbers, anything from
a few to thousands, that need to be priced.  A macro opens a connection to an
Access database of ALL known part numbers and gets ALL the prices, which upon
receipt at the Excel end are loaded into an ...

I have a spreadsheet on a network that links to another workbook containing
source data, formulas etc. Obviously the public version is there to be viewed
by my colleagues but I wish to hide the source data from all users but need
the ability to update the source data. I thought I ...

I have a worksheet (orders) which lists orders by County.
I would like to link the data in Orders (cells A2 to T7) to County 1
worksheet.
I would like to link the data in Orders (cells A8 to T15) to County 2

I am currently using 2003 version of excel, and have a question regarding
links.  I am creating a spreadsheet to track all of our construction jobs.  
Each job has a unique work order number; however, there can be multiple
invoices submitted for each job.  I would like to be able ...