workarounds

Hi :) I usually use a formula that automatically updates the column header to a new number when I insert new columns into my insanely huge spreadsheet. With the new table autoformats I can no longer get this to work. Rather than hand number 50 columns, does anyone know how I might get around...

I have a workbook where whenever I click save the graphs disappear but when i close and open the file again they are there again. I have read up on it and there are workarounds but I would like a permanent fix. Anyone know a way around this...

Hello Basically I want to have a pivottable like below <tbody> <tbody> Center 1 2 3 4 Total average of DT% Sum of DT% Sum of DT% SUM of DT% SUM of DT% Center Name </tbody> </tbody> Sorry if it looks messed, first time on forum. The issue is I can't just put total...

I would like the formula, =HYPERLINK("#INDEX('Dec17'!$1:$1,(ROW(C2)-1)*8+36)",INDEX('Dec17'!$2:$2,(ROW(B2)-1)*8+38)), to work with the fill handle. When I drag it down the name updates, but the link remains the same. I need the C2 to change to C3, C4, etc... Any workarounds? Thanks!