I'm not sure what the issue is. If you're already manually typing it and adding it to a dashboard, why not just change the name when you publish it to include the version #? I may be misunderstanding the issue.
Instead of changing the workbook name, you could either add a title page to your workbook that contains workbook version information, or add a footnote on each sheet that has the version name. If you want to be able to quickly change it for all the sheets, have the footnote be driven via parameter.
Hi Matthew. Once things settle down that would be the obvious option but at the moment there is so much development happening that we have numerous version of each workbook running in dev area all with slightly different things we are trying. People forget to rename the version number when they publish so can't be sure which file is being tested. If we were able to link the filename it would remove that issue. I was just wondering if there was some option for automating the filename. Sounds like there's not
Daniel, we are using title now so I will continue with that approach and also look into footnotes.
Thanks for your replies.
Similar to what Daniel said, you could also create calculated string fields and display the fields in a title or caption. Not sure if that would make it any easier, though. Best of luck!