Sharing my spreadsheet that contains an Excel Table

[sam2142]

Hi all,

I have an issue with my spread sheet and was hoping some could help me find a work around.

My spreadsheet is currently using an query to display a table of results from an Access database on one of the tabs, I had then planned to use v-lookups to populated other areas in the workbook from the imported table data. However, I need the spreadsheet to be shared and I get an error message saying the workbook 'cannot be shared because it contains Excel Tables or XML Maps'.

Obviously this cannot be done using my current method. But does anyone know of some sort of workaround where I can maintain the data connection and have a shared spreadsheet?

Any help greatly appreciated

Thanks

[:) Sixthsense :)]

It's better to avoid shared workbook in this case