3 people run a report and the only super user gets all value errors on a certain field, the other two have no problem. None are designers. Is the problem with Excel or the network?
Date
Votes
3 comments
-
Harry Lewis Hello Victoria -
There are certain permissions settings that can cause this. When the user selects the #VALUE! and clicks the Debug of Check Error button (depending upon the version of the Excel add-in), what additional information is displayed?
-
victoria orlowski When using debug, the field will display, line by line, but then the calculating field that references that cell does not calculate correctly
-
Harry Lewis Thanks, Victoria.
Assuming all hardware/software to be equal, I would suggest contacting the Jet Support Team on this. They may have seen this before, or may have that user create a log file so that they can see details of what is occurring.
Please sign in to leave a comment.