Hello,

First of all I want to thank those who have provided helpful suggestions in the past.

I have been having this problem lately with a price calculator that I have built and placed in a SharePoint drive for several users to do their pricing. The file format being used is Microsoft Excel Macro-Enabled Worksheet. It has one macro but its locked. Also the majority of the workbook is locked to all users with the exception of input cells for the user to edit. The pricing calculator works great. The process is as follows:

The user goes to SharePoint workspace and opens the price calculator and saves into his/her SharePoint workspace.
We use Onedrive for business and also Amazon Workspaces to save our files (both on the cloud).

The problem is when the person saves the price calculator it converts most of the currency formatting to the date format and screws ups a lot of things on various worksheets within the price calculator. This problem didn't happen until we starting using Amazon Workspaces to save our files. This problem doesn't happen every time but periodically.

Has anyone else experience this? If so are there any fixes.
Thanks in advance.

Mark