Hi,
I attach a very simple excel sheet that mimics what I am trying to achieve on a larger scale.
I am developing a spreadsheet that will produce P&L, Balance Sheet and the like and I have a column(s) that the user should be able to put in "Adjustments".
There are no massive NL("Rows".. being returned. It is just quite a lot of NL("Sums" on quite a few rows.
When I run the attached spreadsheet, I then add some "User Data" in the row 1, refresh it and the data disappears!
Assistance would be great please.
Regards
Doug
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi Doug,
The problem is that your key values are dynamically getting the sheet name. The way stored user data works is that Jet Reports creates a very hidden worksheet with the contents of the original sheet with the user's values. Then it uses the key values to copy the stored values from this hidden worksheet back to the regular worksheet. However, if the key values are dynamically getting the sheet name, then they won't match the key values on the original sheet, so Jet won't copy the values back. Does this make sense?
Regards,
Hughes -
Jet Reports Historic Posts That makes sense.
On my bigger workbook I have hard coded the row and column references so that they won't change, and I have a smaller version actually working. So I copied the top left of the "Working Version" to the bigger sheet.
When I input user data and refresh, the amounts disappear. When I click on refresh they come back. One more click, they disppear again and another click brings them back.
[Updated] I have input "Refresh1" into Row 1, Column 1 and clicked refresh, the text disappears.
I then input "Refresh2" into Row 1, Column 1 and clicked refresh, the text disappears.
I then input "Refresh3" into Row 1, Column 1 and clicked refresh and the cell then returns to "Refresh1"
Another click on Refresh and the cell returns to "Refresh2" and so on.
It is obviously storing the data somewhere to be able to retrieve it, but I've got three sub-sets of data for one sheet.
It may be that there is a logical reason, but I'm missing it.
My next step I think is Jet Support, unless anyone has come across this type of "feature" before.
Thanks for your response.
Regards
Doug -
Jet Reports Historic Posts Hi Doug,
Did you try going to the User Data menu in Jet and do "Purge then report" or "Purge then design"? It sounds like your user data is all muddled up and you need to purge all existing user data from the workbook to get things working.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
:D
I purged a few times and it seems to be behaving itself now.
I had a little look at the very hidden sheets, and there were multiple copies of the sheet that was giving me so much problems.
Thanks very much for your help.
Regards
Doug
Please sign in to leave a comment.