cannot share workbook with macro pulling data from another workbook

Hello All,

Thank you for looking into this and trying to give it a go.

I have prepared a workbook with a macro in it that does few things to create a report. One of the "things" it does is pulling a data from another workbook while it is closed. After I save the document as a excel spreadsheet it doesn't let me share the document.

Before I had the macro working only on the opened workbook to pull data from it and it did let me share it after I saved it.

I have got this message popping up:

***Message is in attachment***

Although when checked the maps and tables there is nothing there what this message suggests.

And the code I used to get the data over is:

Please Login or Register  to view this content.

It seems like it keeps the connection with the file and it prevents me from sharing the document.

I would appreciate any suggestion.

Simon

A ListObject is a Table and, as the message says, you can't share a workbook with a Table in it.

Hello,

Thank you for your comment. Informative.

Would you know if there is anything I can tdo to the code to make it pull that data but not to keep it as a table or not to pull it as a table?

Sorry for asking maybe basic questiones from programming/coding, but I am a self thought through recording macroes and reading other ones that were preciously created and finding out what they do.

Thank you

Do you want the code to be run again after the workbook has been shared?

No.

Once the code is being run then I save the workbook as macro free.

But this table still is in it that's why I cannot share it. The code is only being run once.

Thank you

In that case just add:

Please Login or Register  to view this content.

after the .Refresh line.

Hi,

I have added this to the code after the .Refresh line and before End With and unfortunately the macro stopped running on it with an error Message:

Run-time error '1004':
A table cannot overlap a range that contains a PivotTable report, query results, protected cells or another table.

But I have then found the option to do and recorded the following macro:

Please Login or Register  to view this content.

And pasted it after End With

And it worked.

Thank you very much for your help - it did make me think more intensly.

Thank you.