Search results for query: *

Yes, basic structure is the same. Each tab has the fields as in the example attached. The differences are a) number of completed rows b) content of non-calculated cells (obviously!) c) Tab-names That's it, really. Very confusing! http://www.2shared.com/file/2618653/72091501/Book2.html

I am working on an Mail Merge Document with 8 tabs. Usually when I want to merge the data from one tab, I have to "re-find" the source via "open data source" and then open the excel file as an OLE source and then pick the tab I want. Recently whenever I want to change tabs, Word loads the data...

Thanks Macropod, I will try that!

Is it possible your excel is not auto-updating the cells and you have to manually push F9 first to get a result? Also, you wrote that "J12 is a value = 80 (cell format is TEXT)", so is it possible that for excel you try to round not a number but a text field, hence spitting out an error?

But would only affect the dates, right? How about the weird number I am getting?

My office suite tends to act up occasionally (work-computer), and especially my mail-merge feature drives me up the wall. When I merge numerical fields, bizarre things happen: 1. regardless of how the numbers are formatted, they are only entered into the word-doc as a simple number. E.g. the...