Hi guys,

Having a bit of a situation that I hope someone can help me with

Basically, I have an Excel workbook that is used for logging production.
This workbook is linked to an SQL server of ours to import data onto "Data" worksheets in order to VLOOKUP data for the production logging worksheets.

We use an ERP system for the entire business, so any changes to production etc are logged in here, and when the Excel Worksheet is refreshed, the changed data gets imported, easy!

The only problem is, the workbook is a shared server document, and when I try to share it, I get errors about data connections not being allowed in shared documents.

Any ideas as to what I can do?

Cheers,

Nick