Pages

Search

Microsoft Word - Word 2010 not updating Excel 2010 embedded tables

Microsoft Word - Word 2010 not updating Excel 2010 embedded tables

Word 2010 not updating Excel 2010 embedded tables

Posted: 02 Apr 2014 02:06 PM PDT

I have a word document (docx) that references a number of tabs in a single Excel (xlsx) workbook for the related table information.  Despite my best efforts, I have been unable to get the linked tables to update when I make changes to the underlying Excel workbook.

One observation I have made is that some of the older linked tables had a context menu that showed "Update Table", but the current linked tables do not show that context menu.

Here are some things I have tried doing:

  • Placing both files in the same directory on the network, as I understand that the links use absolute path names rather than relative pathnames, so placing them on my individual computer would disrupt the links when other users receive a copy.
  • Disabling all COM add-ins on both Word and Excel.
  • Changing all links from automatic update to manual and back.
  • Opening the excel sheet from the context menu in the Word document.
  • Saving, closing, rebooting, reopening
  • Making the file trusted
  • Making the directory trusted, in both the Word and Excel Trust Center

I expect my problem is that there is a default MS setting against links updating for network files and I just haven't located the setting the allows it to update.  

OS: Windows 7 64-bit

Office 2010

4 GB of RAM

I don't know what other information might be helpful, so please let me know if I can provide anything else relevant.  Thanks.

Find and replace across all section headers in a long document

Posted: 02 Apr 2014 01:51 PM PDT

I have a long, non-English, Word document with more than an hundred sections and unique headers. 

Now, I must employ the new Unicode fonts available in Windows 8.1, which entails finding and replacing some characters.

How can one find and replace across all headers in such a long document, without having to click into 100+ headers?

add contenct to a word document from an access database

Posted: 02 Apr 2014 12:38 PM PDT

I have a master document that I need to add content stored in a Access database. The information is layout in different tables, and will expand through out the entire document in different spots and tables. Which options do I have to accomplish this task?

Mail merge label printing problem

Posted: 02 Apr 2014 11:52 AM PDT

I am new to mail merging, but have walked through the steps and completed an address label merge using Excel 2007 and Word 2007. Everything looks right in the preview function, and the first page of labels (using Avery sheets of 3 rows by 10 rows) prints fine. On the second page, however, instead of printing from what should be record number 31, the merge prints from record number 2, and so on.

Any ideas on what I could be doing wrong?

Thanks for your help.

Dennis

How to - Different Page Numbering Style - On ODD - [A,B,C]; On EVEN [1,2,3]

Posted: 02 Apr 2014 11:48 AM PDT

I have a specific requirement of having different page number style on alternate pages, for example on all the even pages i want page numbering in the Arabic or Letter format and on all the odd pages i want numeric format.

Like:

Even Pages - A, B, C, D .....

Odd Pages - 1, 2, 3, 4 .......

I am able to have different PLACE of page numbering by way of - different odd and even header/footer but not Different TYPE of numbering in alternate pages.

Please Help.

Why can't I download Office templates? I am running a genuine verions of MS Office 2010!

Posted: 02 Apr 2014 11:47 AM PDT

I went to the MS Office site and downloaded one template. I tried to download another, same way (click on the download button). Nothing happens, and I've tried it even after rebooting. The Download button highlights, so I can click it. But then nothing downloads. The template does not go into my Download files and it's not beneath my Chrome browser, either, as all downloads usually are.

Why not? And why was I able to download ONE template in this way, but no more? Is there some kind of limit? I swear that has to be YET ANOTHER Chrome problem, I'm sure! Grrrrr  I'm runing Windows 7, for what it's worth.

Word 2007 won't print because...

Posted: 02 Apr 2014 11:45 AM PDT

I'm trying to print some documents and a couple of excel files and all of a sudden I get this message at the bottom of my Word file that says, "Word is preparing to background print the document."  It won't load up.  I've checked all my "options" and I think they're right.  What could be wrong?  Why won't it print?

Now it's saying, "Printing (the name of the file) (0 pages completed)" and then there's a bar that shows that it's loaded and green.  I'm also getting the "waiting" sign.  I can't close or do anything until it stops doing it's thing.  Please someone help!!!

Tracking changes

Posted: 02 Apr 2014 11:35 AM PDT

There seems to be no help available from Microsoft for this app I just paid $100 for. Also, unless it's cleverly hidden, there seems to be no way I can track editing changes (unlike Apple's free Pages app). Am I wrong? I sure hope so. 

Can't open .docx file using Office 2013 Home and Student. File Conversion and McAfee Endpoint Encryption. Huh?

Posted: 02 Apr 2014 11:27 AM PDT

I am not able to open a .docx Word file and am getting some file conversion and encryption message.  See the image.

How do I open my file?

Can't open word docs

Posted: 02 Apr 2014 10:43 AM PDT

when I try to open my word docs... I get an error message that "Word found unreadable content in....."  When I select yes, to recover that contents I then get another error message that says "we are sorry.  We can't open ......because we found a problem with its contents."  The details then state:  "Operation aborted: max-element-depth constraint violated." what can i do????

How To Print Double sided pages

Posted: 02 Apr 2014 10:10 AM PDT

I have a 500-page transcript to print but each volume cannot be thicker than 225 pages or my binders won't fit. So I want to print page 1, then page 2 on the other side of the paper and so on. The only problem is i can't fit 225 pages in my printer tray. I can only fit up to 125. I understand the concept that if i were to use 100 pages in my tray and then flip the paper over to print opposite side, but then when i put the other remaining 125 pages in to begin printing at page "101", how can i ensure page 102 is going to be on the opposite page? Won't my printer recognize it as new numbering like start back at number one? Help please and thank you in advance.

Megan

Can I disable the "Compatibility Mode" default? - DON'T WANT IT

Posted: 02 Apr 2014 10:07 AM PDT

When I open a NEW document in Word 2007, the document is created in "Compatibility Mode" by default. Everyone I work with / send / view documents from has Word 2007. I want the default to be 2007 instead of Compatibility Mode. I know how to change an individual document, but is there a method to cancel this default for all new documents? It's very annoying!

Using WIN 7

How to eliminate spaces in the beginning of each line and at the end

Posted: 02 Apr 2014 09:47 AM PDT

I have a list of names pasted into word. There is a space before each name on each line and an extra space after the last name. I need to eliminate the space at the beginning of the line and after the last name. 

All the search characters I have found highlight the space between the first and last name as well as the space before the first name and after the last name and I don't want that. I need to know how to search for these spaces separately because I need the space between the first and last name to stay put. 

Please help me

Where do I Find Removing Techniques for Special Marks?

Posted: 02 Apr 2014 08:17 AM PDT

Hello,

I get various "special markings" at different places in my Document, two such markings are (1) A Circle with small lines running away from it's circumference  (2) Non-Solid small little squares.

How do I remove them, and where do I find information on them?

Regards,

Saeed

Microsoft Office switches between documents when printing

Posted: 02 Apr 2014 07:15 AM PDT

Hi,

I have an issue with my Microsoft Office printing. If I have multiple documents open in Office if I print one of the open documents, Office automatically minimizes the current document and opens up the other document. Is there a way to switch the setting so this does not happen?

THanks

Avi

Table title won't appear on same page as table in multiple page table

Posted: 02 Apr 2014 05:53 AM PDT

I have a problem that has come up several times recently. When working with tables that flow over multiple pages, the table title will appear on its own page, the table begins on the next page. I've tried the paragraph setting "keep with next," which sounds on point, but it has no effect.

In the table I'm struggling with now, the location of the page break within the table leaves plenty of room on the page for the title so that's not it. I've queried other editors and found this is a common problem and nobody has a reasonable solution (most common answer: manually break the table into 1-page parts). Any idea how to fix this?

Office 2013 Home and Student Equation Editor Bug: Crashes Word Only

Posted: 02 Apr 2014 05:38 AM PDT

When I do Insert->Equation in Word 2013 on Windows 7 and type any operand (such as !@#$%^&*()_+) using the SHIFT key (or CAPS LOCK ON for the underscore and plus sign) as any character other than the first character, word crashes (doesn't respond and I have to force it to close).

I have reviewed other posts with similar issues and tried the suggested steps here but it did not solve the problem:
http://answers.microsoft.com/en-us/office/forum/office_365hp-word/equation-editor-does-not-work-on-word-2013-office/b99e54d7-2897-4139-9fe4-39a54597c8b0

Let me know of any other information that you would like from me. I'm certain that there's more you'll need to start helping. Like I said, this only happens in Word for me. Excel and Powerpoint are fine. This also happens on new documents and old documents, only when editing equations.

Thanks!

Repeating row equired in mail merge page

Posted: 02 Apr 2014 05:01 AM PDT

Dear ms office Team,

how to create invoice in mail merge in word repeating rows,

like pls see the the below grid, 

INVOICE NO INVOICE DATE ITEM DESCRIPTION QTY RATE VALUE
1 01/04/14 BLUE PEN 10 3.5 35
1 01/04/14 RED PEN 10 4.5 45
1 01/04/14 BLACK PEN 10 4 40
2 01/04/14 BLUE PEN 100 3.5 350
2 01/04/14 RED PEN 10 4.5 45
3 02/04/14 BLUE PEN 50 3.5 175
3 02/04/14 RED PEN 10 4.5 45
3 02/04/14 BLACK PEN 10 4 40
3 02/04/14 GREEN PEN 100 4.5 450
4 02/04/14 BLACK PEN 50 4 200
4 02/04/14 GREEN PEN 60 4.5 270

but i am traying in mail marge in that singale row only comming we reqd mail merge invoice no wise reqd one sheet one invoice no,

can u pls hlep out this problem, 

Why are my Heading 2s appearing before my Heading 1s in my Table of Contents?

Posted: 02 Apr 2014 04:14 AM PDT

I am using Word 2007 and in my Table of Contents, anything formatted as Heading 2 is appearing before Heading 1 in the TOC if they are on the same page. How can I change this? It's very frustrating.

i cant find microsoft office word starter 2010 in my laptop in windows7 excel starter 2010 is there word starter2010 was there few weeks a go. pl help me

Posted: 02 Apr 2014 04:04 AM PDT

I cant find Microsoft office word starter 2010 in my laptop. I am using Windows 7.Excel starter is there but cant find word starter. It used to be there a few weeks  ago. Please help me.

Office

Posted: 02 Apr 2014 04:00 AM PDT

I can't find an answer to this one, the message I am getting when I am trying to open an old word document is

Something went wrong

We couldn't start your program. Please try starting it again.

If it won't start, try repairing Office from 'Programs and Features' in the Control Panel.

So firstly I can't find the control panel in Windows 8...

I have tried starting the program again to no avail, please help

Win 8.1+Word 2013+ChangJie Input Method has a text cursor jumping bug

Posted: 02 Apr 2014 02:06 AM PDT

My OS is Windows 8.1 x64.

My Word is version 2013 15.0.4569.1504 MSO 15.0.4569.1506.

Recently, I was using Chinese ChangJie input method and Word 2013 and found a text cursor jump bug.

That is, first I swithced to ChangJie input method, used my mouse to put the text cursor within a sentence in a paragraph, pressed the Backspace key to delete a Chinese word, pressed a key for spelling a Chinese word, and at the same time, the text cursor jumped to the next paragraph!

Please see this demonstration video:

http://1drv.ms/PhEEgE

The example Word file can be download here:

http://1drv.ms/PhEGF9

Please fix this bug, Microsoft.

WHATH is this? Keyboard OVERLAPPING?

Posted: 02 Apr 2014 01:30 AM PDT

I press ctrl+pd in the hope of jumping to the next page in the same doc instantly when I'm editing multiple docs, whereas the RIDonculous thing is it's not doing its designated work! instead, it does what shift+f5 does, and even jumps among docs! which is so weird!

so WTH is happening? is that an issue? anyway to get it right??

Font not displaying correctly in Word 2010

Posted: 01 Apr 2014 11:17 PM PDT

I have recently installed Helvetic Neue font and it displays correctly in PowerPoint but only displays as Arial in Word.  Not sure why.  Very frustrating as I'm trying to create a word template to be deployed throughout a medium sized organisation with very strict typeface guidelines.  Please advise.

Top margin and page spacing for a file is gone

Posted: 01 Apr 2014 11:11 PM PDT

As you can see here, the top margin is gone. I have no idea what I have changed.

Here, the page number says 3 of 3, but word doesn't show 3 pages with padding in between 2 pages, instead, it shows lines where the page breaks are.This is how it should look like.Any idea on how to fix this?

sending a Word document

Posted: 01 Apr 2014 10:30 PM PDT

Hi,

I am unable to send a document from 2010 Word.

I have windows 8.1 (previously I had Vista and used the same program) and my mail program is an Outlook Hotmail account.

When I re-installed the program on this computer I updated it.

Now - when I attempt to send adocument via email I get the message: There is no email program associated to perform the requested action. Please install an email program, or if one is already installed create an association in the default programs control panel.

Following this I then get the error message : Word couldn't send email because of MAPI failure.

I have trawled through sites (including this one) and often find the same error message problem but every "fix" I have been directed to and tried has not worked.

Thanks,

Chris

Some garbled text in older Word document

Posted: 01 Apr 2014 09:57 PM PDT

Recently upgraded to Office 2010 Home and Student from Office 2003 Student.  Upon opening a few of the older Word documents, some text is garbled.   I've done a lot of online searching and have tried several things that kept being suggested:  1)checked to make certain the older files are in fact Word documents, 2) checked to be certain they had been opened as Word documents, 3) checked to be certain the file extension is .doc, and 3) tried changing the garbled text to ALL the fonts in Word 2010 but this didn't work either.  The symbols changed based on which font I tried, but still nothing is recognizable. 

These documents were created in Word 2003 about 10 years ago.  They are instructions for a class, so any suggestions are greatly appreciated.   

office 365 university word not proofing

Posted: 01 Apr 2014 09:37 PM PDT

initially downloaded office 265 university, worked perfect, no issues whatsoever. after around 6 days it would not allow me to open word or powerpoint documents, or open and create new documents. was advised by shop I purchased laptop and office pack from to uninstall and reinstall. came home and did that, but now word documents will not check spelling etc and says i need to download english (new zealand) however when i go into my language settings it says installed and used as default? esays looming and issues with spellcheck etc is causing extra stress! anyone have any ideas? or should i try uninstalling and reinstalling AGAIN...

garbage characters in header, footer, and comments of Word documents

Posted: 01 Apr 2014 07:50 PM PDT

Here is my issue.

Client has boiler plate Word documents that are used over and over as starting point for similar reports.

These were created approximately 13 years and many office versions ago. Presumably as .doc.  Some 70 pages long and onerous to retype.

Document is passed from person to person in an office, with various personnel replacing boiler plate text with real text.  Adding comments to communicate with other reviewers.  At some point, very suddenly garbage appears in the headers, footers, and comments. (Some of the headers, footers, comments, not ALL). Some remain fine. Examples of bad ones below.

Comment text: 

B¦.¢'Á|ä÷‚Ãlu^]5@ømÌJ7ò»Ä{ 7/hRâEgJõßZy>W¯

Other comment boxes in the document are okay

Header

R2bêÝ¡ŠªÖ‹Å×oŽ‚$ôÚ«

should be precisely this

Engagement Overview

Footer:

¸Ì7þíÙh–"-ˆx«xµ*·Ûe"ç69

MGGsSöéš}ή϶kxÌÚLÓŽT'PbÐÐ'¹PM¶}XSÕ6ÓL6arâ¨%÷¥pRbèìû §I…%ᘛêguáSK¢7%cç‚~¹ÂãT`                                      É&bâix¸±ÉuO&ØwWsq

It should look like this format (info changed for privacy):

© Company XYZ, Inc.

A Member of the companies of company type Network

More details:

1. Documents are now .docx.   They START in 'compatibility mode'.  (Office 2007 mode).

2. Everyone in the office except one person has Office 2010.

3. Documents are password protected.

4. Documents sometimes seem to be converted to Office 2010 mode.

5. Once the 'garbage' appears, it is difficult to eradicate. Though it seems that sometimes if the person with Office 2007 opens it, all is fine, and they can PDF it even.  It doesn't appear that they can 'fix it' for others by opening it.

6. The documents often times have complex mathematical equations.

So, it would seem a boundry issue when crossing between 2007 and 2010.  The difficulty is, there is not a reproducible failure scenario where someone says "do X, Y, Z and the error occurs".   People work for a long time without it occurring sometimes, and at other times it happens fast.

It is hard for me to ask people to 'try this' or 'try that'.  I might want people to keep the document in compatibility mode throughout to see if it solves it.  I'd like to copy the content into a new Office 2010 mode file for the starting boiler plate, but don't know if that would do it.

I have Googled my head off looking for someone with a similar issue, but come up empty. What I'm hoping is, someone KNOWS what the issue, and has a definitive decree that "you can not do that", or "you must do this" to avoid the issue.

Thanks in advance for any ideas.

= = = = = = = =

Additional thought.

If we take the one precise translation:

Engagement Overview  displays as: R2bêÝ¡ŠªÖ‹Å×oŽ‚$ôÚ«

It seems to me the first 5 ASCII characters: 45:6e:67:61:67

turn into:  52 32 62 EA DD  (R2bêÝ)

Binding Complex Data to Word 2010 Template

Posted: 01 Apr 2014 07:43 PM PDT

I have been scouring the web for a very long time trying to determine if/how it would be possible to bind data from multiple Access queries to multiple tables in a Word  template. All I can ever seem to find are examples of how to bind a content control to an xml data file to pull in a First Name, Last Name, blah blah blah... That's helpful to a point, but these models only seem to ever show how to pull data from a single record.

I am trying to determine if it is possible to build a large document by pulling multiple recordsets from various queries in Access and use those recordsets to build/fill-in a variety of pre-formatted tables in a template.

I have been doing this for years using plain old Automation and it still works. But after migrating my solutions from Office 2003 to Office 2010 there was a noticeable decrease in performance. What used to run in less than a minute in Office 2003 can now take as long as 4-6 minutes.

The templates I am filling in are fairly elaborate; they are forms designed and distributed by various State agencies for submitting Insurance Claims of sorts. They are often designed by people who clearly have NO IDEA how to use Word to properly build a document that lends itself to easily filling in data while maintaining formatting. One of the most complex templates is 22 pages 'blank' (before I populate it with data). Once filled in, the document may reach 80+ pages. There are all manner of tables and blank spaces that need to be filled in, or not. In cases where there are not enough rows or "blocks" in the original template, more have to be added automatically, while maintaining the same formatting.

From much of what I have read about the data-binding features of Office 2010, it seems that this should be something that would be easier to do in Word 2010 than it was in Word 2003. And it's supposed to be faster as well! I recall recently seeing an old Webcast (circa 2007?) from Microsoft's Tristan <Davis?> that built a very complex Word file as a way of showing off data binding with XML. But it was non-repeating data.

I also have come across another web cast video that showed another MS guru open a web page and order the complete Word 2007 Design Specification to be built on the server (from data in SQL Server) and presented on his screen. It was something like a 36,000 page document built from a template and a a data store. It took 22 seconds or something miraculous like that.

THAT is the technology I am looking for. Does it exist? Does anyone have any leads on examples for something like this? Will I only find it at the end of the rainbow where the unicorns live?

I am a newbie at xml. And I don't do C#. But I am very confident in my VBA skills and I am very happy to learn more about xml to do this sort of thing. I just need a jumpstart...or a confident, informed answer confirming that the way I was doing it in Office 2003 is the best way there is...

Thanks to anyone who can point me in the right direction, or even shatter my dream! I just need to know...

Best Regards,

Rich P

Create a Photo Directory

Posted: 01 Apr 2014 06:20 PM PDT

I work with an organization which has a photo directory of all the volunteers which is made available in print to them. Some have been asking for a digital version which we can't offer at this point. The original information is in Publisher. Is there an easy way to create a directory with photos to share, possibly in Word or Excel?

Thank you

Word 2013 on internet?

Posted: 01 Apr 2014 06:14 PM PDT

how can I have my documents available to work on when not on the internet?

Work 365 increase the number of pages dramatically when saving

Posted: 01 Apr 2014 05:55 PM PDT

Hello,

I run office 365 and when I load in a particular document it loads and edits fine, but when saving, Word goes nuts and changes it from 12 pages to 115 pages.

The document is basically a big table, it's a safe work method statement.

Word appears to put each row of the table onto one page.

If I save it in compatibility mode then it saves properly.

Regards,

Greg

pdf and editable word documents

Posted: 01 Apr 2014 05:49 PM PDT

I have just installed Word 2013 so this is all new to me.  When I open an attached pdf received through my Outlook email, the message is:  Word will now convert your PDF to an editable Word Document."    How do I turn this off?  I just want to see the pdf in its original form.

Getting Error code 30145-27 from office 2013. How do I fix this

Posted: 01 Apr 2014 04:42 PM PDT

I go this error code. I just bought a computer 3 days ago that came with the free trial. Now I'm getting this error message and Microsoft Word 2013 will not open. How can I fix this since it was pre-installed and I cannot re-install?

Delete a template in word 2013

Posted: 01 Apr 2014 03:45 PM PDT

In older versions of Word if I wanted to delete a template I had created I would simply go File, New and then right click and choose Delete. In 2013 I can see my templates in the personal section but there is no delete option on right click. Surely I don't have to go through windows explorer to locate and delete? Is there an easy way?... thanks