Hui
thank you for your welcome and for your prompt reply.
(Apologies for not getting back to you sooner. This is my 3rd time to attempt a reply, for some reason my earlier replies did not send when I hit send post)
You are correct, the workbook name is Lost Time.xlsx
It is stored on a...
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...