importing a protected excel workbook into Sharepoint
I have created an Excel workbook that has 3 protected sheets. With the help of an advisor, he created some vb script that does not let users input data into columns C,D and E if column A is 0. I now cannot upload this spreadsheet into Sharepoint because it says that protected sheets cannot be uploaded. Is there either a workaround for uploading this sheet into Sharepoint or a workaround for using a conditional statement instead of using code which protects the sheet in order to grey out the three columns. Thank you! Cheryl
June 20th, 2011 6:18pm

Hello Ashish, Sorry I was not exact on this part of the thread...there was a prior thread. I was trying to create a list so I was trying to import the spreadsheet. I can upload it as a doc library, but now I have lost all of my functions across workbooks. I have been informed that I will need to have all formulas in one workbook, not across four workbooks. As for a conditional formula, I had tried a condition that if A = 0 (C,D,E, 'locked','unlocked') and various other statements. None of these worked. If you know a statement that works, I would like to know please. Thank you for your reply.Cheryl Nulik
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 8:06am

Hello Ashish, Sorry I was not exact on this part of the thread...there was a prior thread. I was trying to create a list so I was trying to import the spreadsheet. I can upload it as a doc library, but now I have lost all of my functions across workbooks. I have been informed that I will need to have all formulas in one workbook, not across four workbooks. As for a conditional formula, I had tried a condition that if A = 0 (C,D,E, 'locked','unlocked') and various other statements. None of these worked. If you know a statement that works, I would like to know please. Thank you for your reply.Cheryl Nulik
July 2nd, 2011 8:06am

Hello Cheryl, The issue does not seem to with the files being protected. If you try uploading a simple protected excel file it will work, the issue seems to be with the vb script itself. You can insert a function such that if the column A has 0 value then the columns C,D & E will have no data\or some default value and it cannot be changed.
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 3:38am

Hello Cheryl, The issue does not seem to with the files being protected. If you try uploading a simple protected excel file it will work, the issue seems to be with the vb script itself. You can insert a function such that if the column A has 0 value then the columns C,D & E will have no data\or some default value and it cannot be changed.
July 3rd, 2011 3:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics