Hi,
May I know what is the reason for records not being visible even if the data is successfully downloaded to MS Excel? Initial suspicion on access control was investigated and to the extreme, manager access right is assigned to the particular user but it’s to no avail. It is, however, some PC is able to view the data in MS Excel after downloading. To highlight this, no special blocking is applied to the view nor the form. So, is there anything that I’ve left out to allow the downloaded records being visible in Excel? Please advice.
Thanks ahead!
Regards
Subject: Exported Data is blank in Excel
If you say that data is downloaded on some PC’s I cannot believe it has to do with access rights in your database, because these rights will not be different on another PC with the same Notes ID.You might try to add a print statement in your coding, so you can see what data is downloaded to MS Excel.
You may also try to download the data to MS Word and see what will happen then.
It could be that your MS Office installation was not correctly done on the PC where it goes wrong.
Subject: RE: Exported Data is blank in Excel
I am interpreting some of the original question differently. My first guess is that it may be readername fields. It very well could be exception handling in the code which processes users differently based on access, group membership, field contents in the documents, etc. The suggestion to debug your code is the best place to start. You didn’t say anything about what debugging you may have already attempted or what the code does. A last resort would be an issue with Excel, in my assessment.