Hi...

I have been building a rather large set of Excel worksheets that are designed to track and report on sales leads. Everything has been going along fine, but I now find a recurring issue with the "Master" workbook.

The "Master" workbook resides on a network drive and uses a Microsoft ODBC data query to pull data from 7 individual workbooks also on the network in the same root folder (one for each sales rep) into 7 corresponding worksheets within the Master. From there, I have a series of macro buttons that are used to compile the data into one main worksheet and then break it out by the current status of the account (In Progress or Completed). This all works fine.

The issue I am having is that certain worksheets are being pulled into the Master workbook and seem to be creating their own named range:

\1

The problem with this is that when I copy them over to the Master worksheet, they create a data import query in the position they get copied to. When this process is run the next week, it writes over data in the Master worksheet in a specific spot which creates issues since the whole thing has been created with offset ranges to allow for variable amounts of data week to week.

I have rectified this once by recreating the individual workbooks to remove any hidden formatting, and rebuilding the connection string. This seemed to work, but now the same issue is back with different individual workbooks.

Could someone please let me know what might be causing this so I can correct it once and for all?

Thanks!