Reply to thread

Message

<blockquote data-quote="pedal999" data-source="post: 1898790" data-attributes="member: 408953">Hi,After many many frustrating hours, Apple tried to help, and tested lots of things remotely. but ultimately directed me to Microsoft, as I use O365..Almost immediately I was referred&nbsp; to their linked (paid) troubleshooting service, with 15 mins free advice on first use.They were pretty much no use, especially as the tech I spoke to said it would take longer than 15 mins so he couldn't help.&nbsp;&nbsp; I pleaded for 15 min discussion so I could understand better what I could rule in / out, and at the end of that I was fairly certain I knew the cause, as everything else had been ruled out.So to help others:-Conditional formatting !!On lots of my spreadsheets I use conditional formatting, and when I looked at the conditional formatting rules - they had effectively duplicated themselves many many times, and so each copy / paste was trying to recalculate whether the formatting needed to change.Solution:This was actually relatively simple - delete all conditional formatting and then recreate as appropriate from scratch - was a lot quicker than it would have been to recreate the spreadsheet with values and build the formulae back in.Vary relieved. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="pedal999, post: 1898790, member: 408953"] Hi, After many many frustrating hours, Apple tried to help, and tested lots of things remotely. but ultimately directed me to Microsoft, as I use O365.. Almost immediately I was referred to their linked (paid) troubleshooting service, with 15 mins free advice on first use. They were pretty much no use, especially as the tech I spoke to said it would take longer than 15 mins so he couldn't help. I pleaded for 15 min discussion so I could understand better what I could rule in / out, and at the end of that I was fairly certain I knew the cause, as everything else had been ruled out. So to help others:- [B]Conditional formatting !![/B] On lots of my spreadsheets I use conditional formatting, and when I looked at the conditional formatting rules - they had effectively duplicated themselves many many times, and so each copy / paste was trying to recalculate whether the formatting needed to change. [B]Solution[/B]: This was actually relatively simple - delete all conditional formatting and then recreate as appropriate from scratch - was a lot quicker than it would have been to recreate the spreadsheet with values and build the formulae back in. Vary relieved. :) [/QUOTE]

Verification

Name this item 🌈