Frequently Asked Questions
»
1. How do I use Merge Workbooks?
»
2. What is the maximum number of Excel workbooks that Merge Workbooks can combine?
»
3. Sometimes Merge Workbooks does not copy the entire cell contents. Why?
»
4. I get an error message about Macros being Disabled. Why?
»
5. Sometimes not all the worksheets are copied. Why?
|
1. How do I use Merge Workbooks?
» Click here to visit the Merge Workbooks tutorial.
|
2. What is the maximum number of Excel workbooks that Merge Workbooks can combine?
» This is depenedent on the amount of computer memory. The number of worksheets in a workbook is limited to the memory of the computer system.
|
3. Sometimes Merge Workbooks does not copy the entire cell contents. Why?
» An Excel cell is limited to coping 256 charaters per cell. If there are more than 256 charaters in a cell then the contents of the cell will be truncated to 256 chars when copied. To work around this limit the chars in a cell to 256 chars or less.
|
4. I get an error message about Macros being Disabled. Why?
» By default the macro security settings in Excel are set to High. This macro will not run if the security settings are set to High. You must set the security settings to medium or lower to use this macro. Click here to learn how to lower your security settings.
|
5. Sometimes not all the worksheets are copied. Why?
» This is caused when "Skip Blank Worksheets" is checked. To determine if a worksheet is blank the macro looks for any formulas or text/numbers in a worksheets. If the macro does not find either the worksheet will be skipped. If the worksheet only contains such things as Photos, Drawing Shapes, etc. and no formuals or text/numbers then macro assumes the worksheet is blank. To work around this uncheck "Skip Blank Worksheets" or enter some text in worksheet you want to copy.
|
