Is there a way to use 2019 Excel without OneDrive file conversions to work with earlier Office Excel versions?

Jim Robinson PE 1 Reputation point
2021-09-08T19:48:12.317+00:00

We are required to move away from Office 365 and external drives (OneDrive, Dropbox) to internal NAS for security reasons and evaluating Office 2019 with internal NAS.

Things were going well until we found that earlier releases of Office (2010) could not use the 2019 Excel files when saved to NAS. The Title Bar and 5 lines of the the spread sheet are moved under the Menu and Task Bar targets and can't be moved into the workspace. Several damaged engineering worksheets with heavy VB were found blank, but could be opened by using "New Window" page, but then didn't operate.

Further testing shows coping 2019 Excel files onto USB drives and Internal NAS (Synology family) result in the problem. Then testing on Dropbox and Google Drive show the same problem. The only way to fix it is transferring through OneDrive which is excluded by the insurance underwriter.

Our thinking this is a fatal flaw in 365 and 2019 and to drop back to earlier office versions.

Thoughts?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viki Ji_MSFT 4,411 Reputation points
    2021-09-09T06:14:30.637+00:00

    Hi @Jim Robinson PE ,
    Welcome to Q&A forum!

    Is there a way to use 2019 Excel without OneDrive file conversions to work with earlier Office Excel versions?

    < How did you use the OneDrive file conversion?

    Usually, we open earlier versions of Excel files and work in compatibility mode.
    For more information, please refer to: Use Excel with earlier versions of Excel.

    coping 2019 Excel files onto USB drives and Internal NAS (Synology family) result in the problem.

    < Since we do not have a similar test environment, I cannot test further. Thanks for your understanding.

    Any misunderstandings and updates, pelase let me know.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Jim Robinson PE 1 Reputation point
    2021-09-13T11:30:44.65+00:00

    This was an evaluation of Office 2019 with internal NAS for backup and shared files versus OneDrive. A station with Office 2010 had the corrupted 2019 Excel problem.

    Microsoft support had us repaired Office 2010, reloaded 2010, reloaded Windows 10 Pro and we still have the corrupted 2019 Excel problem. But everything else is fine.

    Now we found going through OneDrive does not necessarily fix the problem all the time.

    So we added another Office 2010 station to the evaluation system and found the problem isn't in the new station.

    It's isolated it to the original station. We're going to give this another week and if we can't find the problem. decommission the original station.