Jun 08 2020 09:01 AM
Why does Excel default to absolute links when you link two workbooks. I nearly always want to copy the formula across several cells (and link to range of cells in source workbook) which means I have to remove the $$ signs every time. Is there a way to make it default to relative reference when you link?
Jun 08 2020 09:47 AM
The truth is I'd never noticed that, and I routinely do make a connection. Anyway, two thoughts short of changing the default--whether or not that's possible, I don't know. Look in the "Preferences" panel.