Hope all are well
I have been putting together metric dashboards, a simple data entry with dynamic charts to view results. I have used the offset function with named ranges.
The problem occurs when some of my colleagues open the file on their PCs. The workbook name in the series reference...