•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power query rounding issue
I have a rounding issue that doesn't seem to have the usual data type solution. The source data my queries are pulling from are in a decimal format. However, power query only sees those decimals as long as the source data workbook is actually open. The moment I close the workbook and refresh the query it reverts back to a whole number.
I have tried changing the applicable columns in the query to decimal number and currency with no success. The only thing that has worked was converting the source workbook from Excel 97-2003 (we use older software that exports to that) to a Macro-Enabled Workbook, which unfortunately would be time-prohibitive given the number of workbooks involved.
Any ideas?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#real-time data collaboration
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#Excel alternatives
#rows.com
#digital transformation in spreadsheet software
#financial modeling with spreadsheets
#real-time collaboration
#Power Query
#Rounding
#Data Type