1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Document Control -- Sharepoint and Excel

Hi, I'm working on documents that contain either an embedded Excel file in a docx or the document record has a docx and an xlsx individually.

For some reason, when we update calculations in the Excel file, the calculations don't "stay" in that Excel doc, if you click on the Fx it will say the link is Sharepoint!My file path! and then the calculation.

Which does no one any good because only I have access to my Sharepoint and these files are accessed by dozens. We've tried everything to remove the Sharepoint reference in one xlsx and as soon as you save, it pops right back in there.

submitted by /u/Roemeosmom
[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
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Document Control
#Excel
#calculations
#Sharepoint
#docx
#xlsx
#remove Sharepoint reference
#embedded Excel
#reference
#calculations don't stay
#document record
#link
#access
#update