Constant problems between Word, Excel and Onedrive


New Member
Jul 7, 2020
Office Version
Good afternoon
I have a huge problem between Office and Onedrive and I can't find the cause.
My PC is an I7 with Windows 10, I work with Office 365 Personal, and the Word and Excel files are on Onedrive.
I have an Excel file with several sheets (data base and forms) that manage employees, contracts, tools, among other things. It has the size of 1.8 Mbytes.
The Word file serializes the employees' contracts.
At the moment there are 4 people using the file, but rarely are more than 2 people at the same time.

Errors are when:

1º The connection between Word and Excel, there are times when you are constantly asking to be connected with the Excel file. Sometimes the entire "Mailing" menu is gray. Just by deleting the file and going to get another file that I have in reserve.

2nd Almost constantly, the excel file gives errors when saving. The errors are varied, but almost always says that you need to save a copy of the file. Other times it says that the file is read-only. Other times we want to save with another name and it gets so messed up, that we have to close the files and lose the information that we had put in the file.

I'm starting to get a little lost in the search for a solution to these problems, so I ask the group for help, to be able to know if it is a hardware error of a machine, if it is from Onedrive, if it is an Excel programming error that I have been to do, etc ...

I really need help from someone who knows what might be happening.

Thank you for your help

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...