Excel spreadsheet problems

Split from this thread.

I have a similar problem with excel freezing. Office 365 Personal.  My spreadsheet is linked to other spreadsheets within onedrive, every time I try to delete on insert a row it freezes.  I have tried coping it to a new spreadsheet but that hasn't worked.

<The thread has been moved to the correct category by forum moderator> 

 

Question Info


Last updated October 2, 2019 Views 497 Applies to:

Hi Sandra,

 

To investigate this behavior, could you provide the following information:

  1. Your OS version and Office version. (Excel>About Microsoft Excel)
  2. How did you link your workbook to another workbook which is stored in your personal OneDrive?
  3. Regarding the problematic workbook, where do you store it? Locally or in your personal OneDrive as well?
  4. Please confirm whether the issue occurs in a local normal workbook.
  5. Please confirm whether the issue occurs when you delete the connection.

 

Regards,

Zixuan

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Zixuan

Answer to your questions:

1.  Microsoft Office 365 Windows 10

2.  I first set up this spreadsheet in Windows 97 using a much older version of Excel - I have been doing these spreadsheet for about 10 years - originally I set up the link by "=and clicking on the cell in the other worksheet that I needed to pick up" - from then on I just need to find and replace each new month with the new months spreadsheet name. 

3.  I store it locally but it is picking up the one drive automatically and has changed the file location to one drive.

4.  I tried getting rid of onedrive but that didn't work and previously I never had this issue on a local normal workbook.

5.  I tried deleting the connection in the rows that I wanted to delete, as I thought that might be the problem, but that didn't make a difference.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Zixuan

Any suggestions on what might be the problem?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.