Page 1 of 2

Excel Pipe fails to open password protected spreadsheets

Posted: Thu Apr 15, 2010 4:54 am
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

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Fri Apr 16, 2010 11:21 am
by DataMystic Support
How are you specifying the path to the Sharepoint Server? Please provide the exact text

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Wed Apr 21, 2010 5:23 am
by stormcrow27

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Wed Apr 21, 2010 11:38 am
by DataMystic Support
That's not a UNC path - you need to provide the UNC path to the sharepoint server.

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Fri Apr 23, 2010 4:35 am
by stormcrow27
I tried the UNC path as you recommmend, same result.

//portaltest.domainname.com/bpp/previous_month

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Fri Apr 23, 2010 8:27 am
by DataMystic Support
UNC paths are

\\portaltest.domainname.com\bpp\previous_month

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Sat Apr 24, 2010 3:51 am
by stormcrow27
Sorry, I flipped the backslashes around. I still receive the same error message.

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Mon Apr 26, 2010 12:15 pm
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?

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Tue Apr 27, 2010 2:33 am
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.

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Tue Apr 27, 2010 9:18 am
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)?

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Thu Apr 29, 2010 12:26 am
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.

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Thu Apr 29, 2010 8:46 am
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.

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Thu Apr 29, 2010 10:20 pm
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.

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Fri Apr 30, 2010 9:13 am
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?

Re: Excel Pipe fails to open password protected spreadsheets

Posted: Fri Apr 30, 2010 10:58 pm
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.