FlyerTalk Forums - View Single Post - Excel Clinic - Adding a Connection to a Table
Old Apr 24, 2021 | 2:14 pm
  #1  
gfunkdave
FlyerTalk Evangelist
Conversation Starter
All eyes on you!
20 Years on Site
 
Join Date: Nov 2002
Location: ORD
Posts: 14,771
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.
gfunkdave is offline