I have a LibreOffice file where i have many html extenral links separated on different sheets.
In the beginning i insterted some forumulas in each of those external link sheets to extract some values to my main sheet ( sheet 1 ). I put those cell somewhere further away where there is no data of course.
Was working but noticed later that on some sheets all the cells moved by theirselves to another row column…
I was ok maybe it was because when the sheet refresh from the updating it mess the cells too so i decide to make a second sheet just next to each of the html external links sheet and put my formulas there so it won’t interact with the html external sheets and thus move the cells by itself.
Well it worked, my cells didn’t move since then and stays at the samle place but… i noticed now that the column letter i assigned in my formulas change by theirselve, i’m kind of confused…
For exemple i assigned $E$150 and on some sheets they become $B$150 or $J$150
What can i do to solve this issue ? Any suggestions would be appreciated.