When you select the cell which is displaying #VALUE! and then click the DEBUG button on the Jet ribbon, what additional details are displayed?
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Hello,
thanks for the answer.
Now I know, what was the problem: limit :-)
You can see it in pictures.
Veronika -
Jet Reports Historic Posts Hello,
in one report I have this problem. Till yesterday it worked, but today I can see only #Value.
Some information about report are in apendix.
Other reports are OK.
Any idea?
Thanks,
Veronika -
Jet Reports Historic Posts Hello, thanks for aswering me.
You can see it in picture.
THX! -
Jet Reports Historic Posts That's a fascinating error message (and not one that I have NOT seen before).
Here is what I found about the error:
https://blog.sqlauthority.com/2007/05/16/sql-server-fix-error-1205-transaction-process-id-was-deadlocked-on-resources-with-another-process-and-has-been-chosen-as-the-deadlock-victim-rerun-the-transaction/
Pinal Dave is one of the best authorities on the Web that I have seen when it comes to SQL Server.
If the issue continues to happen, I can only assume that some process somewhere has a perpetual lock on something needed as part of your query.
I hope that helps. -
VALERIE DEJOIE Hello, I've been using Jet express for Excel (GP) for 2 years now. My trial balance is generated by it. It has always worked perfectly, I've added accounts no problem before but today when I add an account I get an #value error : Key Not Found Exception message
The rest of the file is working fine just the new account has the error. It's an account I added today in GP and entered an expense in it.
What ca I do? Anybody had that issue before?
Please sign in to leave a comment.