Published sheet inside website results in #ref being desplayed

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