Excel Clinic - Adding a Connection to a Table
I have an existing table in Excel (not a pivot table, just a regular table) that I've been updating by pasting in the contents of a similar table I download periodically from a reporting site. I now have the ability to access the same data directly from an Oracle database. How do I modify the existing table in Excel to pull data from the db? I know how to make the db connection. But there doesn't seem to be a way to add a connection to an existing table. I don't want to create a new connection and new table, and delete the old one, because it'll invalidate all the formulas throughout the workbook that refer to the existing table.