Problem Note 68073: Formulas return the value #VALUE and an error is generated when you use SAS® Demand Planning with Microsoft Excel CDA formulas
 |  |  |  |  |
Occasionally, when you use Cell Direct Access (CDA) formulas in Microsoft Excel with SAS Demand Planning, you might see that the CDA formulas return the value #VALUE!. When this problem happens, the following error is displayed in the SAS® Add-In for Microsoft Office log:
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Demand Planning | Linux for x64 | 8.2 | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-07-07 13:20:17 |
| Date Created: | 2021-06-22 16:44:02 |