I have a third party querying product I'm using within Excel, but when it refreshes a query with less rows than the last refresh it deletes rather than clearing the contents of the old/extra rows. This causes any formula pointing to that area to come up with a #Ref error, any ideas how I can get around this?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
#Ref Error
- Thread starter pcawdron
- Start date
Similar threads
- Locked
- Helpful tip
- Locked
- Solved
- Locked
- Question
- Locked
- Question
