Help Stop Query from Ruining my Tables
I really hope someone may be able to help. I built a workbook I’m pretty proud of. That runs several queries off of some imported data. Beside these queries are some tables analyzing the data. (There was probably a better way to do it but the manager I made it for ‘doesn’t like’ pivot tables).
The problem being: when I refresh the query it is shifting cells over and running my tables.
Is there a way to insert a break of some kind so it doesn’t do this? The thought of moving all of the tables is horrible and I’d hate to add more tabs to the long list of the ones already there.
Thank you!
Edit: So I realize they weren’t actually set as tables in excel so I tried that. Now it won’t refresh the queries at all and it gives me an error that cells couldn’t be moved.
[link] [comments]
Want to read more?
Check out the full article on the original site