0
votes
1answer
23 views

Word document loads incredibly slow

I have a word document (286kb) which takes almost 2 min to load. The document contains a large number of excel objects (as links from the same workbook). This is what I've tried: Remove the "old" ...
2
votes
3answers
159 views

Converting a .txt file with tab as separators into a excel spreadsheet

I have lines of data in a text file where each entry is separated by tab. I want them in different columns and each line to form a separate row in excel. I tried using Data > Import but it all comes ...
2
votes
1answer
29 views

Excel is pausing my word doc each time it refreshes the link between the tables that I have in excel and my word doc

I have a word doc with many linked excel tables in it. Every so often, word has to pause while the excel automatically refreshes it. How can I slow down the intervals between refreshing to say once ...
0
votes
0answers
18 views

link excel sheet to word doc and be able to change multiple cell values at one time [closed]

I would like step by step instructions on how to link excel sheet to word doc and be able to change multiple cell values at one time. I have linked up several tables but then if I move to another ...
1
vote
0answers
31 views

Reset Numbered List with Text Style VBA macro MS Word

I'm trying to make a VBA macro to create a Word document from Excel... Currently I'm having issues with setting up the Lists properly. I want the list indexes linked to my 2 header types. Like so: ...
1
vote
0answers
21 views

Mail merge - Change data in source from merged document

I have an excel file with thousands of records. I want to mail merge and build a directory which I have done. The problem is when directory was built I noticed that there were some errors. I want to ...
0
votes
1answer
25 views

delimiting text in Excel messes up hyperlinks

I'm trying to paste a table that should never have been done in Word into Excel. Once in excel, there's a column with three separate sets of data that I wish to delimit into three columns. The third ...
1
vote
0answers
30 views

How to find and replace text in embedded excel spreadsheets in word? [closed]

I need to change the values of a series of tables (about 10) embedded in my word doc.
0
votes
1answer
30 views

how to send a pdf or ms excel/word file while it's open?

Upon viewing a pdf, ms excel/word file, i often want to send to my colleague for viewing, and after sending, i will still need to keep it open to use it further. While each time I have to close it and ...
0
votes
0answers
32 views

How to combine an Excel spreadsheet with word documents using a field from the excel rows matching filename of word doc

I am trying to combine an excel spreadsheet with associated word documents. There is 1 word document per excel line. I have the Excel spreadsheet with all the rows. I have all the word docs in a ...
0
votes
0answers
19 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
20 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
37 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
26 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
77 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
31 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
31 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
54 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
67 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
3k 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
95 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
37 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
250 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
95 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
799 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
75 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
103 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
395 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
159 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
329 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
40 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
31 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
288 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
928 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
290 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
244 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
168 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
933 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
284 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
708 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
43 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
2k 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
144 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 ...