0
votes
0answers
13 views

Trying to make a Bibliography from book database

I try to transform a book database excel to a text bibliography index in word. We need to copy text and formats, in a one line per book text with negrita (for autor), and (cursive) for title, and i ...
1
vote
1answer
15 views

MS Word tables as link from Excel only shows a single line

I have a Word document that functions as a template using a linked table to an external Excel sheet. My problem is that when i 'paste special' to insert the link, the table shows only the last line of ...
1
vote
1answer
22 views

How do you create a mail merge from excel in microsoft word and then overlay multiple images on top of each other

I know how to insert images into mail merge in word one at a time and have them next to each other, but I want to mail marge three images each onto a printable label. The first image is a background ...
0
votes
1answer
21 views

How to define a specific row height for Word table row similarly 'Row Height' feature in Excel?

In Excel we have 'Row Height' where we can enter a number to define the heihgt of a row. I want to do the same in Word but there is no such command when right clicking on the row. And currently we ...
0
votes
2answers
48 views

Adjust decimal separator in imported charts

I am about to write an English document with the German versions of MS Word and Excel. I use Excel to create a chart which I import into the Word document (by Copy & Paste). I can tell Excel to ...
1
vote
0answers
25 views

Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following: 48.8 4.19 (0.36) 4.52% and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...
1
vote
1answer
27 views

Keeping Microsoft from auto starting on Mac

Whenever I start up my Mac Mini (running OS Mavericks) or Macbook Air (OS 10.9), I have to wait while Word and Excel automatically load and open. I've tried stopping this from happening via system ...
2
votes
0answers
47 views

Is there a way to automatically display the file path on every print whether its Word, Excel, PDF

I am working with one of our help desk tickets and I personally don't think it's possible unless you go through some crazy scripting... The help desk ticket client was asking if is there a way to ...
0
votes
0answers
46 views

Margin in Word and Excel sheet

I need Excel sheet in Word (for calculate). I input by Insert / Object / Microsoft Excel Sheet. But I have problem with margin (via screenshot) and I dont know how I can set it? I have Word 2011 ...
1
vote
0answers
64 views

Word 2007 Merge Document - creating only one letter to recipient for multiple records

Record 1: Mary Smith, Barney Record 2: Mary Smith, Pebbles Record 3: Mary Smith , BamBam Record 4: Bill Shoe, Rocky For example, Mary Smith is listed in my database 3 times with 3 different ...
-2
votes
1answer
44 views

Using ms-excel to search and reduce particular repeated values to single value?

I have excel document which has IP address as SourceIp 192.168.2.4 ............ ............ ............ ............ 192.168.2.44 192.168.55.4 ............ ............ ............ ............ ...
3
votes
1answer
2k views

How do I copy Word tables into Excel without splitting cells into multiple rows?

I have data in a Word table that includes line and paragraph breaks. When I copy the data into Excel, it splits each line and paragraph I want into multiple cells. How do I copy the data to Excel and ...
0
votes
1answer
83 views

Office 2013 programs hang when alt key is pressed

I am using Office 2013 on a Dell Windows 8 laptop. When I press the ALT key in either Word or Excel the document I am editing will immediately hang (e.g. trying to do Alt-tab, Alt-F, etc). Other ...
-3
votes
1answer
23 views

listing by one particuluar column in excel for mail merging

I would like to list all of the same students with their courses. My example School Teacher Course ID LastName 705 KELLEY AP PSYCHOLOGY 1245 AARON ...
0
votes
0answers
35 views

Printing 24 labels per page from Excel

I'm trying to print 24 labels per page in Word using Excel list. First page is fine, but when it moves to next page only difference is that second record from first page becomes first record on ...
3
votes
2answers
182 views

Setting default editor language in word 2007

I want to change my default editing language in word as English (India). It is not so possible to change the language setting in all users and all PCs manually. Manually we can change the default ...
0
votes
1answer
85 views

How to copy/paste a Word a file that has a linked formatted text?

I link some datas in a word file in order to have dynamic fields. I do it by this way I add a Text field from Under Developers - Controls - Text. I write something to this text field and copy it ...
0
votes
2answers
590 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
66 views

Word mail merge using excel column to select layout from other documents

I have about 30 word documents. There is 1 document that is the main one setup to use for mail merge. There is a column in the recipiant list that is meant to select the document that will be used ...
1
vote
0answers
90 views

Excel link in Word docx

I use a Word file to put it as a report in which I integrate tables and charts from an Excel file. More precisely, on a network drive I have many Excel and Word files. Each Word file has its Excel ...
2
votes
1answer
310 views

Ms Office files corrupt after recovery

Recently some xls, xlsx and doc, docx files get deleted when reinstalling Windows XP, although the files were on other partition (D:) not on the Windows partition (C:). I have recovered the files ...
0
votes
1answer
123 views

An Excel table embedded within a Word document loses color (grayscaled) when printed, while the remainder of the document has full color

I have a Word document with logos, text, etc. in color. Embedded within the document is an Excel table. The Excel table also has colors. When printed from Excel, the colors are as expected. Within ...
0
votes
1answer
267 views

Exel/Word documents locked/read-only when going offline

We have a number of users on Windows 8 who have an issue with files locking when going offline. The main sceneario is below: Windows 8 laptop connected to LAN on docking station Excel / Word ...
1
vote
1answer
41 views

How to insert delimiter into text that is in a specific format

I am currently using Microsoft Excel 2011 for Mac. I am trying to separate data in the following format with delimiters. So far I have not been able to come up with a practical solution. Can anyone ...
0
votes
1answer
39 views

Is there a way to copy & paste a format style in Word?

I export some data (daily) from Access to Word and each time, I need to take certain formatting steps (about 6 steps) for the final Word Document. Instead of going through each step, one by one, each ...
0
votes
2answers
30 views

Convert folder of word docs into a single, parseable spreadsheet

Is it possible to show MSWord a folder full of .docs or .docxs and have it convert them into a spreadsheet containing columns for different variables that describe each document, such as filename, ...
0
votes
2answers
217 views

How to set character per line limit in word or excel or any other program?

I'm doing an application online and part of a section requires 7 lines of writing. However in each line it requires no more than 130 characters. I have done the 7 lines but some lines are over 130 ...
0
votes
2answers
750 views

Batch filling multiple forms using data from Excel

I have an excel file which contains many rows of data, each row has columns like last name, first name, gender etc. I would like to batch fill these data into multiple forms of different types. ...
0
votes
0answers
22 views

Word and Excel files wrongly locked by another user [duplicate]

I have a problem with opening word and excel files in office 2013. It is said that they are locked by another user. If the doc is closed and then reopend the doc opens normal. And there can be worked ...
0
votes
0answers
273 views

Microsoft Office 2013: buttons/icons/text disappear

A few days ago I opened my Microsoft office programs and discovered that they are missing the editing icons at the top, some of them will appear if you scroll over them, but not all. Also, in ...
0
votes
0answers
230 views

QR Codes Printing, but Not Printing Correctly - Any Ideas?

I am mail merging some QR codes via file paths stored in Excel into a label template in MS Word 2013. I have the whole process with the Ctrl+F9 working properly, but I am stumped on this: On the 30 ...
0
votes
1answer
147 views

UNIX script to LPAD update query in cat file

I want script which will open the text file data and write update query to those file and save in SQL file which will get executed through cron. I have prepared command but its writing the update ...
1
vote
0answers
780 views

Remove 'file locked for editing' attribute from MS Word/ Excel documents

In the same essence as this question Excel file locked for editing. Is there a command I can type to remove the lock flag? for example: attrib -R example.docx -- The story -- In our office we ...
0
votes
1answer
265 views

Generating random tests from a spreadsheet and template in Office 2013

The task I'd like to complete is to keep an item bank in Excel, complete with text for the item, correct answer(s), tags for the item to indicate what it measures and what materials its based on. ...
3
votes
1answer
4k views

How can I move linked Word/Excel files without breaking the links under Windows 7?

I currently operate under Windows XP and have multiple links between my Word and Excel files. I have to upgrade to Windows 7. When the .doc and .xls files are converted to .docm and .xlsm, ...
3
votes
2answers
512 views

Extract data from delinked Excel plot

I have a Word file which has some Excel plots in it. Unfortunately I lost the original excel plots and the word file is now 'de-linked'. Is there a way to retrieve the lost data for the plots? Just ...
0
votes
2answers
42 views

Microsoft Excel 2010 Plugin problems

In our lab environments, we are having some trouble getting the analysis toolpak enabled and available on the data tab in the ribbon. Originally, the add-in is not checked in add-ins, so we check it ...
4
votes
1answer
2k views

Linking Excel 2013 cell to Word 2013 table cell adds unwanted line breaks

I have a problem where I am trying to copy an excel cell that contains content using a formula, into a word document table cell and link them such that the formatting is used in word. What happens is ...
1
vote
1answer
1k views

Copying data from multiple word docs into one excel sheet

I have about 4000 doc and docx files which contain a table. I've managed to import these into one excel sheet using the following script: Sub Macro1() Dim xl As Object Set xl = ...
1
vote
0answers
133 views

MS Office applications (ALL!) always on top

I've searched a while and seen specific Add-on or taskbar lock/unlock fixes for Excel, Word, and Outlook, but I've having the same issue with the windows always staying on top for ALL programs. This ...
0
votes
4answers
1k views

How can you find out if xlsx and docx files are safe to open?

I have received an email from a not entirely trustworthy source, it might be legit but I'm not really sure. It contains, among other things, information on a .docx Microsoft Word file and a .xlsx ...
1
vote
2answers
254 views

link an Excel cell from an embedded document in Word

I have a Word document with an Excel document embedded. I would like to show some values from the Excel in the Word document. Of course they have to get updated when the Excel changes. I know how to ...
3
votes
3answers
1k views

Mail Merge function in Word 2010

I have this Excel file that has multiple sheets that I wish to import to Microsoft Word's letter format. Firstly I started mail merge to this excel file and selected this particular sheet/table, then ...
8
votes
4answers
2k views

How to keep selected text highlighted when focus changes in Microsoft Word/Excel

Related to this question: Show cell selection in Excel when not in focus except that my case concerns Microsoft Word. When I select text or a column/row in Microsoft Word or Excel (2003, 2007, 2010 ...
2
votes
1answer
3k views

Microsoft Word 2013 - Cannot Paste Special

In Word 2013, I am trying to paste the contents of my clipboard which contains a formatted table from Excel into a word document. When I press ALT+E and then press S to bring up the special paste ...
1
vote
0answers
208 views

How can I copy spreadsheet cells into word document?

I'm trying to copy a selection of cells within a spreadsheet across the word and have changes appear in both sp doc and Wd doc. I have read this answer you gave from another with the same quest: ...
1
vote
3answers
185 views

Utility that can print documents and merge the output with several other PDF files

I have a big book that consist of several static documents and a few dynamic ones (primarily Excel with links). The process of printing all this to one PDF as required by my customer takes way to much ...
1
vote
0answers
324 views

Why recovered .xls and .doc files show as symbols?

I formatted an NTFS drive (and re-installed windows) which had some important .doc and .xls files, I used 2 recovery software and both recovered my files but seem to be corrupt, when opened they ...
0
votes
1answer
263 views

Find broken links to other documents in MS-Office documents (Word)

In our team we have a shared folder with all the documents. Most documents contain hyperlinks to other documents. From time to time, we move some files and links get broken. I need a tool that ...
0
votes
2answers
395 views

Increment a cell value every 23rd line

I have the statement below at every 23rd line in an excel sheet CSV format (there are no formulae in the document, I just assumed using excel would be the easiest way to change this!) ...