Published sheet inside website results in #ref being desplayed
I have a control excel spreadsheet from which I then create a simplified version 98% with linked cells. IE file 2 is linked to file 1 inside my computer. I then upload file 2 to zohosheet and go to publish range. The resultant codes I paste into my website but the result shown inside the website becomes #ref in all the linked cells. The only cells to desplay is where I have used standard excel formulae with a link back to sheet 1
It matters not which version of excel I use the same problem occurs
For me this is an issue that suddenly started about 6 weeks ago and would be obliged for anyones help