ExcelPipe Error: RPC Server Unavailable

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

Moderators: DataMystic Support, Moderators

egurry
Posts: 7
Joined: Thu Dec 23, 2010 2:55 am

ExcelPipe Error: RPC Server Unavailable

Postby egurry » Thu Dec 23, 2010 3:45 am

Hi. I am having trouble using ExcelPipe 5.0.2 on a Windows 7 Ultimate x64 machine with Office 2010. I have a large excel workbook (approx 8 MB) that I am trying to perform a search/replace on using ExcelPipe, and it isn't working.

If I close Excel, open ExcelPipe, enter my find/replace terms, select "Look In" (using Cells and Defined Names) and then F9, the dialog box comes up and progress begins. But then I get an error that Excel is not responding and I should switch to it. However, Excel isn't showing up as an open application, although it is listed in the task manager as a running process. Eventually, either I click the restart button or ExcelPipe automatically restarts Excel, the progress completes, but no changes are made to the file. I get the following error message:

C:\Users\xxxxxx\Documents\xxxxx\xxxxxx.xlsm worksheet:0 term:nil-The RPC server is unavailable
Microsoft Excel restarted, reinit commencing

I have tried this numerous times on different computers with the same result. I also tried saving the file as an xlsx file, same result.

I then doing everything the same but leaving Excel open in the background when I hit F9. Now the progress completes without errors, but the file is not changed. The Files Changed tab is blank, and the Files Not Changed tab lists my file with no additional comments.

Any help appreciated, thanks.

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

Re: ExcelPipe Error: RPC Server Unavailable

Postby DataMystic Support » Thu Dec 23, 2010 8:52 am

If you check 'Leave Microsoft Excel visible' then you can see if there are any dialog boxes popping up from MS Excel, by Alt-Tabbing to it.

Other than that, it sounds like you have set ExcelPipe to kill MS Excel if it takes too long (hence the RPC server is unavailableMicrosoft Excel restarted error).

Have you manually verified that the terms in your search/replace list actually exist in your .xls? If so, please send us the file and the list.
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

egurry
Posts: 7
Joined: Thu Dec 23, 2010 2:55 am

Re: ExcelPipe Error: RPC Server Unavailable

Postby egurry » Fri Dec 24, 2010 1:23 am

Thanks for the reply Simon.

I have confirmed that my search term exists in the file's Defined Names.

I have tried checking the Leave Excel Visible button. I have also tried setting the Restart Excel Automatically box to both 0 and 180. But in either case, just a few seconds after the "unresponsive" dialog box comes up, it disappears and the scan completes. Excel displays no dialog boxes. Even if I click Wait, the scan still completes in seconds.

There is no more error now, though. Just a link to the help file in the Files Changed tab, and the path & filename of my file in the Files Not Changed tab.

I can send you my file for evaluation if you'd like. Is there a secure way to do that?

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

Re: ExcelPipe Error: RPC Server Unavailable

Postby DataMystic Support » Fri Dec 24, 2010 8:13 am

Please use our supprot form on the site - feel free to compress the file with a password and send the password separately.

Any documents we handle are in the strictest confidence.
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

egurry
Posts: 7
Joined: Thu Dec 23, 2010 2:55 am

Re: ExcelPipe Error: RPC Server Unavailable

Postby egurry » Sat Dec 25, 2010 2:40 am

Thanks Simon. I tried to upload my file using the support form but the upload failed, with error "The file size of 0 is larger than your allowed upload size". The archive file is around 8MB. Can you send me details on uploading via FTP, or some other method?

And in case I forget, here is the password for the archive that will be uploaded:
saspeVe-uSpES9ured5E-a&R
(Yes, I know that this is a public forum, but it's a single-use password and the file is being sent separately, so I don't care if the password is public.)

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

Re: ExcelPipe Error: RPC Server Unavailable

Postby DataMystic Support » Wed Dec 29, 2010 5:44 pm

Hi - please setup an account at http://www.DetachPipe.com to send it to us
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

egurry
Posts: 7
Joined: Thu Dec 23, 2010 2:55 am

Re: ExcelPipe Error: RPC Server Unavailable

Postby egurry » Wed Dec 29, 2010 5:48 pm

I tried to set up an account, but getting an error that says "The email address is too short. Please use your browser's back button and try again."

My email address is 21 characters, seems like a bizarre error.

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

Re: ExcelPipe Error: RPC Server Unavailable

Postby DataMystic Support » Wed Dec 29, 2010 7:01 pm

Thanks, fixed the DetachPipe error (and created an account for you). Will checkout the download you sent earlier.
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

egurry
Posts: 7
Joined: Thu Dec 23, 2010 2:55 am

Re: ExcelPipe Error: RPC Server Unavailable

Postby egurry » Thu Dec 30, 2010 6:21 am

Okay, now I'm able to log into DetachPipe, but when I try to upload a file I get the following error:

Error - file size (7.9 MB) is larger than your maximum upload size (5 MB).

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

Re: ExcelPipe Error: RPC Server Unavailable

Postby DataMystic Support » Thu Dec 30, 2010 7:34 am

Ok - changed this to 10MB for 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

egurry
Posts: 7
Joined: Thu Dec 23, 2010 2:55 am

Re: ExcelPipe Error: RPC Server Unavailable

Postby egurry » Thu Dec 30, 2010 9:48 am

Thanks, file is uploaded.

egurry
Posts: 7
Joined: Thu Dec 23, 2010 2:55 am

Re: ExcelPipe Error: RPC Server Unavailable

Postby egurry » Thu Jan 06, 2011 4:02 am

Hi Simon. Just wondering if there is any update on this? Thanks.

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

Re: ExcelPipe Error: RPC Server Unavailable

Postby DataMystic Support » Sun Jan 09, 2011 4:24 pm

Sorry - annual holidays have arrived. Our office re-opens on the 30th Jan, so we will investigate this issue then for 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

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

Re: ExcelPipe Error: RPC Server Unavailable

Postby DataMystic Support » Thu Jan 27, 2011 3:25 pm

Hi Eric,

We tried running this here with ExcelPipe 5.0.5 against MS Excel 2003. The file opened (after a conversion popup window), and it took a long time to make any changes. I recommend setting the 'Restart MS Excel if unresponsive for this many seconds' to at least 60 seconds.

What search terms did you use?
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: No registered users and 1 guest