Simply inserting an empty line in Excel results in a recalculation (I guess) of a lot of SeoTools-formulas because it takes minutes before I can continu. Is there a way to solve this issue?
Or is there a way to disable seotools while I'm editing the sheets, after which i can activate it again resulting in recalculation of the formulas?
I have the same problems on my side. Sometimes Excel calculates a lot after very small changes in the spreadsheet and NOT directly to the SEO tools formulas, e.g. only inserting a new column. Is there any way to avoid this?
Furthermore, does anyone know how to refresh the results of a formular that was entered some days ago?
Thank you for any kind of further info.
Anybody an idea for a solution?
When adding new columns or rows, try not to move any existing cells with formulas in them. In other words, if columns A through F have formulas in them and you want to add a new column, add it to G instead of somewhere in between A through F
The updates can be time consuming especially on any project making http requests.
On my project I had the formulas generated by macros which then swapped the formulas for plain text.
This makes my project portable.
Eg Put a url in A1. A button called button1
and in project add macro
Sub Button1_Click()
' Checks if website in A1 links to google with nofollow
Cells(2, "A").Formula = "=CheckBacklink(A1, " & Chr(34) & "http://www.google.co.uk" & Chr(34) & ", , True)"
' Turns active formula into static text (no updating)
Cells(2, "A").Value = Cells(2, "A").Value
End Sub
