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

submitted by /u/damon_mo
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article