Forum Discussion

MikeGanem2's avatar
MikeGanem2
New Member
1 year ago
Solved

All Excel Files are Getting updated When One File is Updated

I have several folders, each with some Excel files in it on OnDrive.  Each of these files are copied from one original file by copying and renaming so they have different name under different folders...
  • nilendraFabric's avatar
    1 year ago

    Hello MikeGanem2 

     

    If the files were copied using “Save As” while AutoSave was enabled, they might retain links to the original file through OneDrive’s synchronization system. This can cause changes in one file to propagate across others.

     

    Save a Copy instead of “Save As” to create a completely independent copy.


    there is Edit Links or Workbook Links, depending on your Excel version in Data tab. Look for the Queries & Connections group or in All Commands

    If there are any links pointing to the original file or other external sources, break them by selecting the link and clicking Break Link.

     

    See if this helps