asked on excel formulas not staying with file
Have a user that has an excel file emailed to them from another user. They open the file and add some formulas to it and save it to a folder and then email it back to the other user. That user (the one that emailed it in the first place) edits some of the formulas and creates new ones and types some info in the file and when they email it back to the user that created the formulas, the formulas are not there. I know it sounds weird but that is what THEY say is happeing. I have not witnessed this with my own eyes. Any ideas?
Microsoft ExcelMicrosoft Office
Last Comment
Brian B
ASKER
they are in different offices
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
they are in different officesZalazar's idea of making a new procedure is good. Alternatively use a cloud drive where they both have access.
ASKER
The user sent me this screenshot. Sorry about the quality. Does this have something to do with the problem?
Screen-Shot-2018-02-21-at-8.05.15-AM.png
Screen-Shot-2018-02-21-at-8.05.15-AM.png
ASKER
Hey. Just found out from the user that the excel file is linked to 3 other reports! and only the main excel file is being emailed . Would this make the problem we are experiencing? I assume it would.
It would explain why the data wasn't what they are expecting, but it wouldn't explain changes not being carried.
I would say that I already said they should save the document first and only send links before you accepted the second answer that said the same thing.
Better that they use a link to the actual file location on the network and not try and attach it.