When I apply restricted permissions settings to an excel worksheet and
distribute the worksheet to other users my chart formatting changes and
sometimes the data in the chart disappears completely.

Is there a way to keep this from happening?