|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
Excel worksheet in Word linked text boxes
I am used to "linked text boxes" in Word documents for "text", having it
"jumping" from one box to following ones.
I need, though, to use the same "style" for Excel worksheets. Apparently,
"linked text boxes" applies only to texts, not other type of "objects", like
The cenario is the following:
1. Have a Excel Wsheet, with a number of calculations grouped in separated
"tables" (actually, the Excel fle is only used to format and program the
2. Some cells are linked to others (ex: the result of one cell may be the
input value for another cell in another "table", throuh Copy / Paste Link,
3. In my Word file, I want to display each Excel Wsheet "table" accross the
document, in sequence (1st "table" first, then word text comments, then 2nd
"table" followed by corresponding text comments, and so forth).
4. Furthermore, I would like to have the Excel Wsheet EMBEDDED in the Word
file, not linked, so to have it as part of the Word document.
The reason is that the Word file must be a TEMPLATE (*.dot), so to allow
other users to use it independently AND (I repeat, AND!) allow them TO FILL
the Excel Wsheet cells in the different "tables" along the document, with
values of their own, and so having the "pre-programmed" Wsheet cells to yield
The Word document is, typically, a BUDGET PLAN report, to be written by
different groups of people into separate Word documents (reason for the
template initiative!), where the Excel Wsheet tables refer to expected
"Costs" (itemized as Staff, Transports, ...) and expected "Revenues"
(itemized as Funding, Sells, ...), as an example.
I already tried using Word Tables and Table Formula to perform the
calculations (simple arithmetics of sums, subtractions, multiplications, ...)
and "transfering" the result cells into other cells by Copy /Paste Link them,
but... IT DOES NOT WORK!! When entering the DOT file and transforming it as
DOC file, all the links are lost, as well as the formulas!!
Neither works Copying and Pasting each table from the Excel Wsheet into the
appropriate locations in the Word document, because Word considers the
different tables such created as DIFFERENT Excel "objects", and so, losing,
as well, the established "links" between cells in the SINGLE Excel Wsheet.
My attempts to use Word linked text boxes didn't work either! Apparently
because it seems to be ONLY applicable to common text, not Excel Wsheets.
In fact, after establishing the linking between the text boxes in the Word
document, and copying the WHOLE Excel Wsheet into the first text box, it does
not pass the exceding content of the first text box into the following ones,
as it happens with common text.
Does anyone know how to solve this?
If present version of Word does not allow this type of application for
linked text boxes, I think it would be an interesting feature to build in
Presently I am using MS Office Word and Excell 2003, in Windows XP
I antecepatedly do appreciate your (urgent!) help and experience for this
Looking forward to hearing from you, please accept my best regards.
LNEC / DHA
|Thread||Thread Starter||Forum||Replies||Last Post|
|In typing dates in Word, i.e. "January 12" how do you keep the "1.||Carol||Microsoft Word Help||2||January 12th 05 09:09 PM|
|word xp crashes after macros are recorded||kharris0405||Microsoft Word Help||3||January 11th 05 11:50 PM|
|WP Delay Code - Word Equiv||Mike G - Milw, WI||Microsoft Word Help||6||January 10th 05 05:12 PM|
|How to change merge forms from Word Perfect to Microsoft Word||dollfindance||Microsoft Word Help||2||December 30th 04 04:35 PM|
|Outline||Renee Hendershott||Page Layout||2||December 25th 04 03:49 PM|