I have a workbook using extensive range names. We are using a wonderful
program to publish this document to a dashboard, but it does not handle range
names well. The file takes a long time to refresh and open when using range
names. We have proven that we can increase the refresh time by more than 10x
if we use cell references versus range names. Does anybody know of an easy
way to change range names back to the cell references . . . ?