1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/ColoradoSkater
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#rows.com
#natural language processing for spreadsheets
#query
#tables
#Excel
#workbook
#refresh