ExcelPipe replace in protected sheet with no password

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

Querulus
Posts: 1
Joined: Sat May 31, 2008 2:32 am

ExcelPipe replace in protected sheet with no password

Postby Querulus » Sat May 31, 2008 2:52 am

I'm trying to update UNC links in numerous Excel workbooks. The sheet in the workbook that contains the link is protected, but no password is used. Working on some sample files, I can make the replacement if I unprotect the sheet prior to running ExcelPipe, and I can similarly make the replacement if I protect the sheet with a password prior to running ExcelPipe and then provide the password in ExcelPipe. In fact, I've just discovered that if the sheet is protected with no password I can still make the replacement if I provide a password in ExcelPipe, but then the sheet ends up protected with that password. I could live with that, though it's not ideal. Is there a way to run the replacement, leaving the sheet protected but with no password?

User avatar
DataMystic Support
Site Admin
Posts: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: ExcelPipe replace in protected sheet with no password

Postby DataMystic Support » Sun Jun 01, 2008 10:47 pm

We'll have to check this - my understanding is that it tries to unprotect with no password first. Will have to get back to you.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “WordPipe, ExcelPipe and PowerPointPipe Support”

Who is online

Users browsing this forum: Baidu [Spider] and 3 guests