•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query with sticky manual columns. Is there a fix
I have built a tracker at work, it pulls last 3 month data into a power query to track. However on the power query table tab we need manual columns to allocate work to colleagues, add comments and settlement dates etc which are all manual.
This obviously doesn't work as while the power query is dynamic, the manual cells 'stick' so whenever someone refreshes the data it knocks everything out of whack. I cannot figure out a solution to make this work
Any help or advice would be appreciated, thank you
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#Power Query
#manual columns
#data refresh
#tracker
#dynamic data
#allocate work
#settlement dates
#comments
#Excel
#colleagues
#data pull