The links used within two worksheets in same workbook saved in One drive is broken

Boova Raghavan 0 Reputation points
2023-03-04T07:43:01.66+00:00

The problem does not occur when we saved files in local drives it happens only when the files are saved in one drive.

The problem is the excel file saved in One drive doesn't recognize links between two worksheets in the same workbook.

For ex: say first worksheet is a summary sheet capturing the totals from remaining worksheets in a workbook. When i save this excel file in one drive it does not recognize these links between worksheets so if i make change to the totals in the remaining worksheets it does not get updated in the summary sheet.

Please resolve the same so that using one drive yields good working experience.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,325 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,488 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
835 questions
OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,137 questions
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,647 questions