Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: nicknick33
- Order by date
-
How do I keep the formula ranges from changing when I refresh linked Access Tables
It reads from the sheet that has the linked table. When it refreshes, the reference gets lost or replaced.- nicknick33
- Post #5
- Forum: Microsoft: Office
-
How do I keep the formula ranges from changing when I refresh linked Access Tables
Thanks for the info Skip. Basically I have billing data imported into a table in MS Access. I then have several querries set up to separate the data into groups. I linked those queries into an excel sheet where I run calculations to audit the billing data. For example, one table linked to a...- nicknick33
- Post #3
- Forum: Microsoft: Office
-
How do I keep the formula ranges from changing when I refresh linked Access Tables
I have created a workbook with several worksheets in it. Some of the worksheets are linked to Access Tables and the other worksheets use these linked tables as the source of information. The formulas use ranges as well as mirror the linked tables with some additional columns that have...- nicknick33
- Thread
- Replies: 17
- Forum: Microsoft: Office
