BusinessObjects Board

Workbook protected

other Xcelsius - Crystal Dashboard Design
#1

Hello,

I cannot change name of my excel sheets. When I try to change the names I have the following message: “Workbook is protected and cannot be changed”. If I try to unprotect the workbook I have to enter a password which I don’t have.
This is strange I never set a password on the workbook.

Thanks

JFCab :fr: (BOB member since 2009-01-22)

#2

possible solution:

Dont have your cursor in a cell that contains a formula when trying to change a workbook name…I have seen this cause the error that you are seeing.

Dont have Excel running separately from Xcelsius at the same time.

Your workbook may be corrupt. This happened from time to time in Excel 2k and 2003. A workaround is:

1)Export the Excel book from the Xcelsius model with Data>>Export. Close Xcelsius. Open the book with Excel, try to change something. If the workbook is indeed protected you will get a message saying so.

  1. If so, then make a new Excel file, and copy the worksheets into the new file. Save.

Make sure the worksheet names match exactly.

  1. Reimport the new file into your model.

**Changing worksheet names will break all your component bindings. You will have to re-bind them. Also, sometimes, even when the worksheet names match exactly, you will lose your bindings on import. Its not supposed to happen, but it does with versions 2008 sp1 and above.

  1. If you never get a protected message with the exported Excel file, then just reimport it into the model.

Remember not to have Excel and Xcelsius open at the same time during this process.

Cairmor :us: (BOB member since 2008-06-05)

#3

Thanks a lot for this explanation.

First option doesn’t work so I need to export and import as you mentioned.

Thanks again !

JFCab :fr: (BOB member since 2009-01-22)

#4

Hi

Are you using XL2007? If so try:

going to Excel > Review > Protect Workbook > Protect Structure and Windows whilst in the XLF, and type the password
faz0h1+u

cdavies :uk: (BOB member since 2005-01-28)

#5

Hi,

I am using XLS2007. I tried this password but it’s not the correct one.

JFCab :fr: (BOB member since 2009-01-22)

#6

double post… removed content.

https://smpdl.sap-ag.de/~sapidp/012002523100013296622009E/xcelsius2008_fp21_rn.pdf

Cairmor :us: (BOB member since 2008-06-05)

#7

The correct password is an Upper Case “O” and not zero as shown in the referenced SAP document.

JerryH52 :us: (BOB member since 2008-08-15)

#8

I can’t believe that password worked… I thought that this was completely bogus and didn’t want to try it but I was desperate and it worked.

Thanks

scbobj22 (BOB member since 2009-02-23)

#9

The password trick did not work for me (BI4 SP4), but I was able to get around it.

  1. Save workbook out to an XLS file
  2. Using OpenOffice, save it as an ODS file
  3. Upload both XLS and ODS to Google Drive asking it to convert to GDocs format
  4. note: the XLS will likely fail with a >400,000 cells error (huh???)
  5. Download the now converted ODS file back as an Excel document
  6. Import back into Xcelsius

It’s crazy, but it has worked consistently for the last couple weeks for me here.

EDIT: You may try the steps laid out on the SAP SCN page: http://scn.sap.com/thread/1480563

Michael Lowden (BOB member since 2012-09-26)

#10

unbeleavable!!
the password (fazOh1+u)
worked!!

It worked for me also in Excel2010! (Xi 3.1 SP5 and Xcelsius 2008)

(I also tried Excel2013 but that didn’t work)
UPDATE
correction it also seems to work for excel2013

But I’m curious to know: what is it that makes Xcelsius to set this password?

Tiny :netherlands: (BOB member since 2004-11-10)

#11

My best guess based on the activity I’ve seen is that the workbook gets locked at some point during the binding process. I can’t tell if it always gets locked and usually gets unlocked, or only sometimes gets locked. Since doing little things like renaming sheets can cause such havoc, Xcelsius tries to minimize it.

Lugh (BOB member since 2009-07-16)