-1
votes
1answer
22 views

Extract chart data from Word document to CSV files automatically

I have lots of charts in a Word document in docx format. If I click on Edit data, I get an Excel window which displays the data. From there, it's easy to export it to CSV. How is it possible to ...
0
votes
0answers
33 views

Build report from Excel file with multiple tabs?

A friend saves the data about her students into an Excel file with multiple tabs (one per year, since the list of students changes every year.) Because there are too many columns to fit in a report, ...
0
votes
2answers
320 views

Insert/Display Two-Page Word Object in Excel Sheet

I've trying to take a two-page Word doc and insert it into an Excel 2010 worksheet. I'm not trying to link to the original document. So far I've been able to insert the object, but it only displays ...
1
vote
0answers
42 views

Word converting linked excel objects to text table when updating

I have several Excel tables that I have embedded as linked objects in a Word file. They look great for the monthly report. However, when I go to update the Word doc the following month with updated ...
1
vote
1answer
126 views

Repeated header rows disappear after linked table is updated in Word

I am trying to figure out how to prevent Word from removing the "repeat as header row at the top of each page" option when a linked table is update in Word. I have ~300 linked tables in one document ...
0
votes
1answer
69 views

IF statement with mail merge doesn't work

I'm trying to recreate a mail merge in the way I specified in an old question Mail merge - show line at empty cells However, now the formula doesn't work. The structure of the documents are as ...
0
votes
1answer
237 views

Mail merge - show line at empty cells

I'm setting up an account list for a symposium. I'm using a simple excel document that merges to a word dokument. The word dokument is then to be printed so every user can sign his account. All the ...
0
votes
1answer
977 views

Unable to create Hyperlink from Excel 2010 to a Bookmark in Word 2010 document

I have tried but am not able to create Hyperlink from Excel 2010 to a Bookmark in Word 2010 document. The bookmark is in place in word document. But while clicking on Bookmarks button after browsing ...
2
votes
1answer
215 views

Word 2010 - Paste as Excel “Paste Link” - have table objects which are linked together

I don't know if this can be done or if my one line heading is correct for my question. I sometimes have elements such as a table that I reuse by copying it multiple times.. This cause a problem if I ...
0
votes
1answer
304 views

Is it possible to Link to Excel File Based on Dynamic Mail Merge Field?

If I were to create an excel sheet with merge fields for a Mail Merge, and one of those fields were to be a file location, for example, can I then create a link in my Word document to a second Excel ...
1
vote
1answer
207 views

Why won't my Excel 2010 spreadsheet appear in my Word 2010 document?

When I try to embed an Excel spreadsheeet in a Word document by clicking Insert → Table, "Excel Spreadsheet", a spreadsheet does not appear. Instead { EMBED Excel.Sheet.12 } appears and Excel ...
2
votes
2answers
1k views

Office 2010 prompts for login to SharePoint when editing local documents

I have MS Office 2010 installed and we have intranet sites using SharePoint 2007 and 2010. When I open a document from my hard drive or create a new document in Word or Excel, I get a prompt to login ...
0
votes
1answer
279 views

Printing labels in word, starting in a specific (offset) cell

This is probably super simple and I'm just overlooking something... I hope. I'm creating labels in Word 2010 and pulling the data from Excel 2010. I've got them laid out perfectly, but I need to ...
2
votes
1answer
339 views

Macro Find: Is there a macro to Format a Word Document as if it were beign created in VBA?

I have a lots of code(for Excel) in Vba and would like to transfer a copy of it into a word document. Does anyone know of a macro that will format the word document to treat the code as if it were in ...
2
votes
3answers
8k views

Excel and Word document In same PDF using Word/Excel 2010?

In Word and Excel 2010, you can save Word and Excel file as PDFs natively. Can you combine a Word and Excel file into the same PDF using this PDF save functionality?