I have this new problem that started yesterday.
I have a large, multi-tab spreadsheet - and a lot of the columns within the tabs are grouped for better visual experience.
The grouping normally opens only when I click on the plus sign.
However when I am trying to link a cell from one tab, to another tab that has the grouping in it, all the grouping automatically unwinds without me asking, and it takes me ages to find my way around it. Also all the column letters within the groupings get highlighted in blue colour - see the attachment.
I have no idea why this has sudddenly started happening, can anyone help with this? Thank you
Hi Joanna,
Welcome to our forum!
I just tested linking a formula from Sheet1 to Sheet2 which contains collapsed grouped columns and I didn't have it auto expand.
Not sure why it would have changed for you. Are you able to share your file so we can test it on our PC?
Mynda
Hi Mynda,
Yes, thank you - I attached the file here. Fisrt tab is just blank, this is where if I want to link something to the second tab - the grouping unwinds.
Hi Joanna,
You like many others make the serious mistak of adding sample files with external links like this one to you farsightingconsultingltd.sharepoint
Nothing does anything and I don't see any grouping ... ???
Hi Joanna,
I can't reproduce the expanding of grouped columns when I try and link a cell on the 'Link sheet' to the 'FTE & DAYS DEMAND' sheet. Strange that you are getting this error.
The only difference may be that I am not allowed to see the file CONSOLIDATED BUDGET 2023-24 v3.xlsm as I don't have access to your SharePoint site.
Mynda
