Thank you for your response. But I have gone thru the same thread before submitting in this community and it did not help me.
Below is the URL that we are currently using to navigate from WORKBOOKA to WORKBOOKB:
(Upper case is just to highlight .. the url is all lowercase).
Appreciate your help.
figured out the solution:
We need to truncate he server name from URL and then the relative URL works