Excel Pipe fails to open password protected spreadsheets

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

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

stormcrow27
Posts: 10
Joined: Thu Apr 15, 2010 4:44 am

Excel Pipe fails to open password protected spreadsheets

Post by stormcrow27 »

Good afternoon. I'm trying to use the latest version of ExcelPipe to replace links on several Excel spreadsheets. These spreadsheets are located on a Sharepoint 2007 Server document library, and the cells are password locked to prevent changing the forumla as well as the links to other spreadsheets. Whenever ExcelPipe inovkes Excel to replace the links, it generates a RPC call error, number 82 from Excel Pipe. The links and the spreadsheets change monthly, so ExcelPipe would be an excellent solution to use if it didn't generate this error.

Version of Excel 2007 with Office SP 2.


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

Re: Excel Pipe fails to open password protected spreadsheets

Post by DataMystic Support »

How are you specifying the path to the Sharepoint Server? Please provide the exact text
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Excel Pipe fails to open password protected spreadsheets

Post by DataMystic Support »

That's not a UNC path - you need to provide the UNC path to the sharepoint server.
stormcrow27
Posts: 10
Joined: Thu Apr 15, 2010 4:44 am

Re: Excel Pipe fails to open password protected spreadsheets

Post by stormcrow27 »

I tried the UNC path as you recommmend, same result.

//portaltest.domainname.com/bpp/previous_month
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Excel Pipe fails to open password protected spreadsheets

Post by DataMystic Support »

UNC paths are

\\portaltest.domainname.com\bpp\previous_month
stormcrow27
Posts: 10
Joined: Thu Apr 15, 2010 4:44 am

Re: Excel Pipe fails to open password protected spreadsheets

Post by stormcrow27 »

Sorry, I flipped the backslashes around. I still receive the same error message.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Excel Pipe fails to open password protected spreadsheets

Post by DataMystic Support »

It doesn't look like a UNC name. It looks like you're trying to use a URL with UNC syntax.

Is portaltest.domainname.com a UNC share on your computer?
stormcrow27
Posts: 10
Joined: Thu Apr 15, 2010 4:44 am

Re: Excel Pipe fails to open password protected spreadsheets

Post by stormcrow27 »

Yes it is. It's also the URL of the Sharepoint portal. I have it mapped in Windows Explorer to go straight to the site. For some additional information, Excelpipe does find the Excel files using this UNC path. It just failes to invoke Excel properly to edit and update the links.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Excel Pipe fails to open password protected spreadsheets

Post by DataMystic Support »

Ok - do you have MS Excel loaded on your current machine? What version is it?

Could you please atatach your ExcelPipe settings and a sample file (or email them to us)?
stormcrow27
Posts: 10
Joined: Thu Apr 15, 2010 4:44 am

Re: Excel Pipe fails to open password protected spreadsheets

Post by stormcrow27 »

Excel 2007, Service Pack 2 for Office. The webserver keeps blockigng the epp attachments from Excel pipe when I attach them to this post. The excel files I'm using for testing are confidential data, so I can't attach or email them due to security reasons.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Excel Pipe fails to open password protected spreadsheets

Post by DataMystic Support »

Please attach as .zip. The .epp is non-secure. Can you remove the sensitive data and still reproduce the problem for us? I am sure it is just a settings issue. Can you please email these to us - and a screenshot of the error will help too.

Looking forward to helping you.
stormcrow27
Posts: 10
Joined: Thu Apr 15, 2010 4:44 am

Re: Excel Pipe fails to open password protected spreadsheets

Post by stormcrow27 »

Unfortunately, my trial ran out, so I can't get Excel pipe to reproduce the error without some sort of extension. However, I can summarize the error.

On the search and replace screen, after Excelpipe lists the files it finds in the directory, and launches Excel to change the links, it reports an error code 12 RPC failed to launch, and then Excel fails to open. This happens on each Excel file.

I've attached the epp files as a zip to this post. Thanks for your help.
Attachments
Portal Excel pipe.zip
(769 Bytes) Downloaded 3177 times
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Excel Pipe fails to open password protected spreadsheets

Post by DataMystic Support »

If you send an email to support we can send you an extension.

First try opening task manager (ctrl+alt+del), look for excel.exe in the task list. If it is, kill all copies and try again.

If that doesn't work, please re-install Microsoft Excel. An RPC error indicates that it cannot connect to MS Excel - either because it was never installed, or (more likely) the installation is corrupted.

You're not running on a virtual server are you...? e.g. Citrix etc where other people can be running Excel on the same CPU?
stormcrow27
Posts: 10
Joined: Thu Apr 15, 2010 4:44 am

Re: Excel Pipe fails to open password protected spreadsheets

Post by stormcrow27 »

No, Excel is installed locally. I've killed the excel.exe processes when the RPC error appears, and it still has the same issue. Excel doesn't have any problems opening the files normally, just when it's prompted by Excelpipe. I've reinstalled Excel and it has the same problem. I'll email support for an extension.
Post Reply