I have webservice cells on some sheets. they link to prices of assests on a webpage. they work fine, but, when I add another sheet to the file, it breaks the links and I get Err:540 or#VALUE! Why is this and how can I fix it?
We don’t know your file nor the formulas used. Please attach a sample file where that happens to your question, click ... three dots and then the pencil, and then the upload icon. Thanks.