Hi Mark
In that case here is a little trick that MIGHT work. No garuantees but it is worth a try.
1. Open a MS Word document and change the view to Draft (i.e. not Page layout view. Then click on the show-hide button to show paragraph formatting in the blank document.
2. Open your spreadhseet and select the contents using Ctrl+A then Ctrl+C.
3. Alt+Tab to your MS Word document and enter Ctrl+V to paste the contents into the word document.
4. Enter Ctrl+A.
5. Then enter Ctrl+Shift+(Left Hand Arrow once). This has the effect of deselecting the last paragraph mark in the Word document (I will explain why at the end of these instructions).
6. Then enter Ctrl+C to copy the contents.
7. Alt+Tab back to Excel and open a new workbook then enter Ctrl+V to paste the contents back into Excel and se if that makes a difference.
To explain step 5 in a little more detail, what MS Word does is to store the formatting for the whole of the MS Word document in the last paragraph mark. By using the Ctrl+Shift+(left arrow once) before you copy (Ctrl+C) you potentially leave any bad formatting behind before you re-paste your data back into a new Workbook.
I have had this issue before with Word documents and it has worked.
Good luck and let me know how you get on.
Tony
|