Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 12: Question about updating a table tied to a SQL query
I have a worksheet that contains a table linked to a SQL query. I have
added some columns to the sheet which contain additional information for each row in the table through a series of macros. If I refresh the data connection to pull in the latest items from the SQL table it throws off all of the data in the columns I have manually added. Even if I make sure my worksheet is sorted in the same way my SQL query sorts the data I have the same problem. All of the additional information I have added gets misaligned. Is there a way to manage the addition of manually entered data in to a query-based table successfully? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Tied Teams in League Table by Matches Between Themselves | Excel Discussion (Misc queries) | |||
Excel Pivot Table or Access Cross Tab Query Question | Excel Discussion (Misc queries) | |||
Web Query Updating Question | Excel Discussion (Misc queries) | |||
Microsoft Query with more than one parameter gets tied up | Excel Discussion (Misc queries) | |||
Help with updating query table from internet | Excel Programming |