•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Extracting all formulas from a multi-sheet Excel file into R (best approach?)
I’m working with a large complex convoluted Excel workbook that has multiple sheets, lots of formulas, and some circular references. The goal isn’t just to read the data, but to actually understand and reconstruct the logic. Just sick and tired of going back and forth between sheets, and I keep forgetting what the logic is. so I have to start all over again
I'm currently going cell by cell and writing all the formulas so that it will be easier later on for reference as well
But I don't know of a way to extract all the formulas at once in a markdown document and develop like a map or something
I use R quite a bit, Is there an easy way to extract all formulas at once and map them ?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#generative AI for data analysis
#google sheets
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#large dataset processing
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel
#formulas