1 min readfrom 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 ?

submitted by /u/sporty_outlook
[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
#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