fiberboysa
Board Regular
- Joined
- Apr 25, 2012
- Messages
- 106
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a workbook containing several external links. But the thing is I have roughted these external links through cells in the same workbook for example formula in a cell is appearing like
instead of
.
Due to above change in SUMIF formula now excel do not perceive it as a external link and Data -> Queries & Connections ->External Links is disabled.
I share this file with my colleagues and I want to find a way to quickly paste all external link formulas as values so they do not get an error when they open these files.
Any suggestion?
I have a workbook containing several external links. But the thing is I have roughted these external links through cells in the same workbook for example formula in a cell is appearing like
Excel Formula:
SUMIFS(INDIRECT("'"&$AA$2&"["&$AD$2&"]Aug 21"&"'!"&"$G:$G")
Excel Formula:
SUMIFS('D:\User Name\STA\JCW\2021 - 22\10 21\[Closing.xlsx]Aug 21!$G:$G")
Due to above change in SUMIF formula now excel do not perceive it as a external link and Data -> Queries & Connections ->External Links is disabled.
I share this file with my colleagues and I want to find a way to quickly paste all external link formulas as values so they do not get an error when they open these files.
Any suggestion?