AS400 Transfer to Excel with a Locked Cell

30 pts.
Tags:
Excel 2000
Exporting AS/400 to Excel
Microsoft Excel
Hi everyone I hope someone can help me with this. I have an Excel template for a download for a group of users. The cell containing the formula was requested by management to be locked due to some of the users incorrectly removing the formula or leaving old data in cells outside the screen view area. I have one user that is able to use the template and transfer with no issues and 5 others that cannot. Our infrastructure person figures it is a setting that is different in the Excel and/or machine of the user that has full access. All other users receive an error message stating the cell they are trying to update is locked. Does anyone have any ideas on what to try? I have recreated the Template and tried only formula locking as well as cell locking following Excel's methodology. I have even tried adding VBA commands to the Excel workbook. Thanks for any help that may be offered.

Software/Hardware used:
Excel 2000 9.0.6926 SP-3, iSeries Navigator V5 R4 Modification 0, i520 V5 R4
ASKED: January 29, 2010  7:19 PM
UPDATED: February 4, 2010  4:45 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi
you tried to set permissions on the cell itself on excell denying or allowing users?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following