Good morning to you all,
I have created a workbook with a few sheets containing sales data with the aim of combining results from our previous quickbooks numbers to our current SAP numbers using the Vlookup function to match customers with their sales amounts.
In the first iteration I was able to create relationships and use the function to match everything up and it worked fine. However, I later discovered an error in my SAP query that omitted credits, cancelled invoices and other items which gave me incorrect results.
After getting the right numbers I then created a new workbook with new tables and imported all of the data that needs to be combined.
However, when I try to create the new relationships the only tables available to me in the Relationship building dialog are those from my previous workbook. I went back to the other workbook and deleted the old relationships but that didn't work. I then deleted the old workbook but all of the old tables are still listed and the new ones are still not there.
I am at my wit's end trying to figure out what the problem may be. Does anyone have an idea why those artifacts are still there while the new tables are not? If more information is needed let me know.
Thanks in advance, Bill
