Excel Issue with saving, losing connection

Question

question

BmoreOs-2852 asked Apr 20, '22 Crystal-MSFT edited Apr 27, '22

Excel Issue with saving, losing connection

Hi -

An end user has been working with a spreadsheet for months with no issues. She adds a new worksheet every week and adds in stats for that week for the work sheet. The summary worksheet is then edited each week to include a summary of all the information for the last 4 weeks.

This week, she went to copy 3 columns (3 weeks) and move them over to the first column but when she pastes, Excel will show "Saving" at the top and never saves. Eventually a message appears at the top "Reconnecting to server as soon as the connection is restored, we'll complete your last actions". It never ends up saving and and a generic error populates.

This sheet contains stats for several employees so each row is an employee's stat for a location. There are about 20 rows per employee. This ONLY occurs on one particular employee and no other employees. If we only copy half or so of the 20 rows and paste, no issues. We seem to narrow it down to the last 10 rows. Nothing is different from rows that work to rows that don't. Formulas are all the same and there is no odd data in the rows, just numbers. We have even tried to remove formulas for this section which did not fix it.

Anyone have any idea what is causing this and how to fix it?

Thanks

office-excel-itpro office-itpro

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CeasarChenMSFT-3458 · Apr 21 at 02:53 AM

Hi,
I'm working on it and will reply when there is progress.

0 ·

Answer 1 · 2022-04-21T09:01:16.473Z

emizhang-msft answered Apr 21, '22

Hi @BmoreOs-2852,
Where did you save the file?
How did you open the file, from Excel desktop or Excel online web?
I suggest you check the Firewall and Antivirus software, try to disable them.
Try to clean the browser cache, for different browsers you can refer to this artilce to get more information:
https://www.fvsu.edu/how-to-clear-your-browser-cache/
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Clear the Web Credentials and Windows Credentials:
1. Open Contral Panel
2. Click Credentials Manager
3. Delete all lists from Web Credentials and Windows Credentials
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response 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.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-04-21T12:20:46.423Z

BmoreOs-2852 answered Apr 21, '22

Hi @emizhang-msft -

Thanks for helping. This file is on the end user's OneDrive. We opened it within the web and via the desktop application. Antivirus was shutdown, along with the firewall and 3 different browsers were used in private mode. We also had 3 different users try with the same file, same results. That would eliminate a single user issue and the Windows Credential.

Thanks

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 3 · 2022-04-21T14:01:44.467Z

BmoreOs-2852 answered Apr 21, '22 emizhang-msft commented Apr 27, '22

Hi @emizhang-msft -

I believe I found the issue. The rows that have the issue, I went to conditional formatting - Manage Rules and there is a longggggg list of duplicate conditional formatting rules listed there. I cleared those rules and everything works as normal now. What would cause those duplicate rules?

Thanks

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft · Apr 22 at 09:35 AM

Hi,
Did the unique Conditional Formatting is created by users before or display automatically?

0 ·

BmoreOs-2852 emizhang-msft · Apr 22 at 12:38 PM

Hi @emizhang-msft -

Conditional formatting was completed 2 years ago on the file but it was only one rule for each cell. The conditional rule is if the cell number is < 0 (negative), make the font RED. But what caused the issue was that numerous cells had an unending list of duplicate rules of the same < 0 conditional formatting rule.

So yes, the rule was created by a human but something caused it to mass duplicate throughout many sheets/cells, etc. We have it fixed for now but I bet this will happen with other documents in the future and I am hoping to understand what caused it, to prevent.

Thanks!

0 ·

emizhang-msft BmoreOs-2852 · Apr 27 at 06:39 AM

As far as I know, sometimes if you copy and paste values with CF cells, the rules will be created automatically.

1 ·

question