ExcelPipe FAQ

This is a collection of frequently asked questions about ExcelPipe. 

Questions

• Q. How can I use ExcelPipe on a SharePoint site?
  A. Map your SharePoint site as a network drive.

• Q. How do I disable AutoRun macros while I run ExcelPipe?
  A. ExcelPipe does this for you.

• Q. How do I search inside Text boxes?
  A. Check the 'Shapes' Look In location.

• Q. How do I remove carriage returns within a cell, entered with Alt+Enter?
  A. You can't - this is an Microsoft Excel limitation. If you can File\Save As the file as CSV (Comma delimited format), then you can apply our TextPipe Pro tool.

• Q. I am trying to replace a date but it is never found.
  A. If you open Excel and put your cursor in the date cell, you will find that the date data (which is what ExcelPipe scans through) is different to the formatted date displayed. E.g. 28-Feb-07 is displayed, but the data in the cell is 28/02/2007. You must be very careful to match the actual cell content exactly.

• Q. I get the message "Access to code modules disallowed. See the help file under Code Modules security"
  A. See here

• Q. Why does ExcelPipe occasionally appear to hang?
  A. This occurs when Microsoft Excel is trying to display a dialog box, such as for a missing linked document (note: ExcelPipe does NOT pause for missing passwords. If you have not specified the correct password, these files are logged for manual handling). Simply press [Alt+Tab] to get to Microsoft Excel, then clear the dialog box. Once this is done, ExcelPipe will resume at normal speed.

Other help resources

• Troubleshooting Guide
• 
• Tutorials and User Guides
• Other downloads
• Configuring a floating license
• Online discussion forums
• ExcelPipe Online Manual (Download) - press F1 or click on Index or Contents in the Help menu. Various translations are available here.
• Technical support