Forum Discussion
How to best manage what should be one table, but across several worksheets?
Hi all! The member registry of our NGO is extensive. We are doing segmentation and collecting information about each of our member associations on several themes. One Excel sheet with one table wo...
Hi Matt!
The Existing Connections doesn't give me anything.
I dug around a little more, and I'm leaning more and more towards a single massive table, be it only for ease of use (can't expect our interns f.ex. to know how to use pivot tables or other arcane Excel things).
You will only see a Table section on the Existing Connections if you have a table object in your workbook. Once this is set up you would only need to teach interns to click the Refresh Button. Even better you can set the data to refresh on open. Then they never need to do anything and it manages itself...
Step 1:
Step 2:
Step 3: