•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do you keep Excel data in sync with the rest of a project?
In a lot of projects, important stuff starts in Excel, but it usually doesn’t stay there.
A number from a sheet might end up in a report, a slide deck, a doc, or some other project file. Then the spreadsheet changes later, and suddenly I’m not sure what else needs to be updated.
In practice, I usually end up digging through files, copying numbers over, and updating things by hand. After a while, it gets hard to tell what’s already been updated and what I might have missed.
Curious if other people run into this too.
How do you usually handle this? Is there a better way to keep Excel data connected to the other files in a project without manually chasing everything down?
[link] [comments]
Want to read more?
Check out the full article on the original site