-3
votes
1answer
22 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
19 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
60 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
35 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
53 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
43 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
36 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 ...
1
vote
1answer
87 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
29 views

I have a Word File with an embeded Excel Table and the Print is colored expect the Excel Table

The Problem is this: I have a Word File (with Logos etc. in Color) with an embeded Excel Table (Table also has colors), when I copy the Excel Table into Excel it selfs and print it is correct colored. ...
0
votes
1answer
95 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
37 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
33 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
27 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
57 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
245 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
18 views

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

I have a problem with word and exel files in office 2013 that the say that they are locked by another user. If the doc is closed and reopen the doc opens normal. And there can be work from the exel or ...
0
votes
0answers
222 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
114 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
76 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
433 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
192 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
1k 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
1answer
120 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
1k 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
529 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
102 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
630 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
109 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
675 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 ...
3
votes
3answers
689 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 which I would set a bounty for, except that a) I have so few points to offer that I doubt anyone will take the bait and b) my ...
2
votes
1answer
2k 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
152 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
131 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
241 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
240 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
266 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!) ...
1
vote
1answer
211 views

Several Word & Excel files are not opening and report “locked for editing by another user”

When I try to open a Word file, it reports error: xyz.doc is locked by editing by 'another user". I'm using Office 2007 and the errors are mainly with files which are "Microsoft Office Word 97 - 2003 ...
1
vote
1answer
123 views

how to update word file - excel file link in batch?

Word file A has about 100 charts, all of them are linked to about a dozen excel files under folder B. Now, to try something new, I made a copy: Word file A1 and folder B1. However, all charts in A1 ...
0
votes
0answers
131 views

Using Hyperlink in Access to link to excel spreadsheet

I am trying to link a cell in a table in Access to some specific spreadsheets in an Excel workbook. I used the hyperlink and put the address like this "My%20workbook.xlsx#Sheet12!a1" , it work ...
17
votes
5answers
1k views

How to simultaneously rename a file in MS Office and delete old version?

In Microsoft Office, when wanting to save a file to a different file name without keeping a copy of the previous file name, doing so requires two steps: First, File -> Save As... and select the new ...
2
votes
1answer
209 views

How to config Microsoft Office Application (Word / Excel) to stop adding personal information to the document?

I have created word document (*.doc or .docx) or excel documents (.xls or *.xlsx). Sometime, these documents need to be sent to some customer and therefore require personal information to be removed ...
1
vote
1answer
52 views

Re-using conditional formatting in MS Office (Word/Excel)

I very often find myself with a formatting that I want to apply to several specific but isolated parts of a document or worksheet, without disturbing the format of the surrounding areas. The ideal ...
1
vote
1answer
187 views

Transferring only tables from Microsoft Word to Excel through automation

Is there a way that I can automate the copying of information from Microsoft Word tables to Microsoft Excel tables?
1
vote
0answers
71 views

Changing size of linked Table of Contents from Word to Excel

I have a Table of Contents in Word that I've linked to an Excel document. It works great, updates appropriately except for one problem. If I have a section in my Table of Contents, let's say 11.1, and ...
1
vote
0answers
420 views

Excel/Word on MAC - includepicture containing url

I have the following: A excel spreadsheet with names and url's to a QR code, each in a column of the spreadsheet. The url returns a jpeg picture of the QR code. A word doc where these names and ...
1
vote
2answers
858 views

Microsoft mail merge incorrectly formatting numbers

I am doing a mail merge in Microsoft Word and pulling the data from an Excel spreadsheet. The text is being inserted perfectly, but when I go to insert a number value, the number goes out to fifteen ...
2
votes
1answer
886 views

VBA to save document in Excel and Word periodically (AutoBackup)

I want to create a VBA script that would save a copy of the document every 5-10 minutes with a new name. The script would keep like 10-15 copies in the same folder, incrementing a number each time. If ...
2
votes
2answers
5k views

How to combine several records in a single letter using Word mail merge

I have a long Excel list with data in the following format: A, B, C x, y, z1 x, y, z2 x, y, z3 I want to create a mail merge in Word 11 for Mac in the following style for each x, y , which is ...
0
votes
1answer
266 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 ...