Issues with Excel tables linked to Word

I have a Word document that includes several linked Excel tables.  Since 
converting to Office 2007, when we open the Word document, it opens and 
closes the Excel file in the background once for every table in the Word 
document.  I have tried changing the links to be manual update only but it 
didn't fix the problem.  Since there are several tables linked to the Excel 
file, it takes up to 10 minutes to open the Word document.  Does any one have 
a solution for this?  Any suggestions?
0
Utf
6/5/2010 4:44:51 PM
word.docmanagement 5542 articles. 2 followers. Follow

1 Replies
778 Views

Similar Articles

[PageSpeed] 21

That is the issue discussed in the thread at 
http://techrepublic.com.com/5208-7343-0.html?forumID=101&threadID=245533&start=0

I have an idea that if you start afresh with a new 2007 format document and 
insert the links, the issue has been overcome.

At the time that it first appeared however the work around that I came up 
with was to use VBA code to insert the data into a bookmarked range in the 
document and write the source of the data (the address in the LINK field) to 
a document variable with the name of the bookmark and then to break the link 
to the source to overcome the timing issue when the document was opened.

Then if it was desired to updated the "linked" data in the document, a macro 
was run that accessed the document variables to get the bookmark names and 
the address of the original LINK fields that was stored in them and then 
grabbed the data from the source in Excel and updated the information within 
the bookmark.

-- 
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"So confused" <So confused@discussions.microsoft.com> wrote in message 
news:1A35C255-75A4-4DD8-8953-0E688EB48A58@microsoft.com...
> I have a Word document that includes several linked Excel tables.  Since
> converting to Office 2007, when we open the Word document, it opens and
> closes the Excel file in the background once for every table in the Word
> document.  I have tried changing the links to be manual update only but it
> didn't fix the problem.  Since there are several tables linked to the 
> Excel
> file, it takes up to 10 minutes to open the Word document.  Does any one 
> have
> a solution for this?  Any suggestions? 

0
Doug
6/5/2010 10:13:52 PM
Reply:

Similar Artilces:

How to display a field from a different table in a list box?
Hello everyone! I'm trying to create this flow action without sucess: I've a form with a combo box (with a list of values) and a list box. What I want is to select a value from the combo and display in the listbox, one colunm of one specific table. This is possible to do? hi, Bluduckx wrote: > I've a form with a combo box (with a list of values) and a list box. > What I want is to select a value from the combo and display in the listbox, > one colunm of one specific table. > This is possible to do? Yes, take a look at the RowSource property of the ListBox. mfG...

Format issues
I have created a template in word which I call through a VB script from excel. The excel data is populated in the word every time I run this script. Everything works fine and the data get populated. I have a header in the template which is represents one of the fields in the excel sheet. The header shows the correct linked value for the first 10 pages but then on shows the variable name instead of the value. I have no idea why it does that? can someone help The code is as follows: For iCurrentRow = 1 To iLastRow If ActiveSheet.Range("B" & iCurrentRow...

Precision in Excel 2002
Hello, All! I have read complaints about lack of agreement in the coefficients of polynomials obtained by fitting trendlines on the graph and those obtained from LINEST. I had occasion to do some experiments yesterday using a third order polynomial with Excel 2002 and, as far as I can tell, at the same number of decimal places the coefficient results are identical. The data used had random errors and was not from an exact curve. Can anyone tell me which versions of Excel can be relied on or else what problems I should look out for? James Silverton Potomac, Maryland E-mail, with obv...

Preventing Excel Time format
An Excel (2000) spreadsheet that I use regularly has had its column formats (though fortunately not the data) corrupted following a PC crash. There's a couple of columns that I use for storing latitude and longitude data in the format eg 52:00:00. Since the corruption, Excel insists on treating this column format as Time (and adding a Date prefix if I try to edit one of the affected cells). I know I encountered this same problem previously and managed to fix it but can't remember the fix. If I select the colum and do Format Cells | Text then all the values immediately change to decima...

Excel 2007: Vlookup Problem
I don't use Vlookup much and it's not working for me. I know it's user error so can you tell me what I did wrong? I have two worksheets in my file. In the first one, I have a list of addresses with a full unabbreviated US state name in column T, row 2. Column U is blank because I want to put the two-digit state code in there (starting with U2). In the second worksheet I have the full state name in Column A and the two-digit code for it in Column B (rows 1-50). Here's my formula starting in U2: =VLOOKUP(T2,StateCodes!$A$1:$B$50,2,FALSE) What is wrong? ...

Editing Chart Data Table
I have a bar chart with 2 different series of data (Item cost in $, and % of total volume delivered). I want to create a data table under the chart, but have it only show the values for the volume delivered and not the item cost. Is there a way to exclude data from the data table? Thanks. ...

Excel Crashing with Outlook
Can anyone advise me what the problem is and how to fix it with Excel. What happens is I might be working on a spreadsheet in Excel and then go to outlook to send an email and Excel then crashes causing me to lose all my work. I know one should regularly save one's work, but to have to do it because you're sending an email is just rediculous. Does anyone know the solution. ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - ...

Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange 2003 on a new domain. This was performed with the exmerge utility in a 2 step process. Now there are 2 issues with Oulook: 1) When a user types a recipient name into the address field, the name autocompletes as normal. But when the mail is sent, a message returns saying it is undeliverable. However, if the user goes into the Contacts folder and from there selects the same user to send a message to, it is successful. 2) If a user shares a calendar, specifying the user with whom to share and the level of permissions, all users in ...

Taskbar issue
Hello All I'm hoping someone can help me with this long-standing problem with both XP and Vista on separate laptops and every computer I've had (except I think Win98). I'm thinking there may be no solution, but what it's worth a try. With both of my machines, I have the taskbar (as well as other toolbars) set out to maximum size - typically half the screen - and to auto hide. (This makes a great program and file launcher) The issue is that the operating system decides it wants open the taskbar on its own from time to time on its own. Various things prompt this, ma...

DST issue
I entered the catalog item: <Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" /> and confirmed that the device has the registry key: HKLM\Software\Microsoft\Clock\AutoDST = 1 But the device still does not automatically adjust for DST. I set the timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one minute...and the time changed to 2:00AM instead of 3:00AM. What am I missing? Thanks. which OS version are you using? have you updated it with the relevant qfes which deal with the changing in DST starting day? -...

Excel 2007 Sheet with rows more than 15000
While working with excel sheets having rows more than 15000 lines, sometimes I observe that the processing is slowed down if data more than 15000 lines is selected. However the work is takes very less time if number of rows selected are less than say 12000. I have 2GB RAM, Can someone help me on this issue? I'm not sure what type of help you're looking for. Excel 2007 is what it is, and you either need to select more than 15,000 rows or you don't. Other than purchasing and installing more RAM on the computer or buying a newer, faster computer with tons of RAM I'm not s...

excel front sheet
Don't know if this is possible?? I have a excel doc which basically calculates lots of different costs. I want to use a front sheet which has fields of input a "GO" button to export the data to the relevant sheet and then clears ready for the next entry. Is it possible within Excel or will my front sheet need to be done in access. If so how do I do that.?? In 2007: Click the office button > Excel Options > customize, then select commands not in the ribbon from the choose commands from toolbar, scroll until you see form and add it - you will then see an icon of a form in ...

Excel 2007
One of the features that I have often used in previous versions of Excel is having a control (e.g., a spin button) in a chart. Obviously, the control would be linked to the spreadsheet from which the chart gets its data. I cannot get this to work in Excel 2007. I am using the B2TR. When I try to put the control on the chart, I get a status bar message that says to click and drag, but nothing happens. Have they eliminated this functionality? I really hope not, since this is very valuable for presentations in my finance classes. Thanks Tim - I didn't test this very thoroughly. I do...

Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can recieve it using Outlook. There error says that Outlook was unable to access the SMTP server. I cannot access my email at HOME through the web email. What I can do is send/recieve email using Outlook Express AND I can access my email through my web email client outside my home. My ISP (SBC) says its not them and I'm somewhat inclined to agree with them? They say I could have a corrupted kernel32.dll file. I have turned off my Norton, deleted my account and set up a new one and re-installed XP professiona...

How do I link Excel pages to a different master Excel workbook?
I am trying to take part lists from different assemblies and link them to a master part list. Ideally one sheet from the assembly part lists will have many pages and be linked to a sheet in the master part list with the name of that specific assembly. I am operating on Midrosoft Office Version 2003. open both the master and your part list on your master if you set a cell to (="name of part list book"!A1) you can do that by clicking any cell on the other workbook with them both open its just like a formula on the sheet only instead it has the workbooks name first i hope thi...

Extender Install Issues
GP 8.0 Extender install - I'm encountering the following: *Login to GP brings up screen: "Great Plains Extender needs to finish installing. This may take a few minutes". It has an OK button and clicking on this gets you into GP but it comes up everytime. How can we stop this from popping up all the time. *When creating a new Extender Window and I get select the Form, I get the following error: "A remove range operation on table 'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or function zDP_EXT40101L_1 has too many arguments spec...

Pivot Charts from Excel not to update automatically
Hi there, I have a pivot chart in Excel and want to copy this to Powerpoint. Copy>Paste obviously works fine but as soon as I change the pivot table feeding the chart, e.g. adding row data it updates the chart in powerpoint. How can I prevent this from happening as I want to copy>paste different variations of the pivot chart into one powerpoint presentation? As soon as I do this it updates all graphs in the presentation to whatever the pivot chart is showing at that time... Thank you for any help! W In article <D77A8CB0-C1C5-47BD-8401-6D6658239842@microsoft.com&...

Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to be able to use some of the tables and subtables as a sort of checklist for the audits. The table/subtable structure is as follows: Topic -->Subtopic -->ProgramArea -->ProgramRequirement I decided to create a report that will output that data. However, the report is only outputting information if there are ProgramRequirements already entered for a given ProgramArea. Is there a way to get it to output the ProgramArea and ProgramRequirement even if blank? Or am I going about th...

Adobe issues
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are unable to send documents to PDF from GP - the PDF option remains grayed out. We have folowed the KB articles that are available, no success. Do we need to install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe 9? Thank you for any assistance.. Hi Susan, I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0 It is working succesfully. -- Geoff James "Susan" wrote: > We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...

Issue with formula is Pivot table
I have the following formula in a pivot table: =IF(ISBLANK(Qtr[-1]),IF(ISNUMBER(Qtr[-2]),(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) First to the issues that I am experiencing. First, the formula wa originally added as the one below but then updated to the formula abov to correctly reflect what I was trying to accomplish. =IF(ISBLANK(Qtr[-1]),IF(Qtr[-2]<>0,(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) This issue is the original formula appears in the very first cell o the pivot table and then periodically through out the column. So, yo see ...

Any help with Excel Toolbar?
I'll admit, I'm not a good Excel user, or google searcher, so I'm hopin someone can help me. If you have a google toolbar, you customize it, then use it, but clos excel and reopen it and it goes back to how it was before....? Is thi normal or is this something I can fix? The file it creates i excel10.xlb in the documents and settings\username\applicatio data\microsoft\excel directory. Any help would be most appreciated. Thanks!! Stephani -- Message posted from http://www.ExcelForum.com Normally any changes you make to your Excel toolbars are saved in your XLB file and rest...

Excel Templates be modified?
I'm trying to modify templates in Excel XP and 2003 and can't get it to work. Possible? Please advise. Some Templates have worksheet protection enabled. Tools>Protection>Unprotect Sheet. No password required. Those from Spreadsheet Solutions containing macros have the VBA Project Passworded. Not knowing what alterations you are attempting and what "can't get it to work" means, makes it difficult to offer more. Gord Dibben Excel MVP On Wed, 16 Mar 2005 18:51:02 -0800, "Frenchfish" <Frenchfish@discussions.microsoft.com> wrote: >I'm...

Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users, Starting over the last two weeks (possibly after an update on the Exchange server), all of my users are starting to encounter the same issue when using Outlook Web Access (using IE6 on XP Pro systems). We have images in our signature block, and now when someone replies using Webmail to an e-mail originally sent via Outlook 2003, a login prompt appears for each image in the e-mail. Every time you cancel the login box, a red x image box appears, until all of the images that should be there are represented by the red x boxes. For the record, this has w...

Print a 2-sided document in Excel for a 3-ring binder?
How do I print a 2-sided document in Excel for a 3-ring binder? I have tried everything I can think of, but the margins on the backside are identical to the margins on the front and that doesn't work. The right margin on the back needs to be like the left margin on the front in order to punch holes in the document. Any help you can give would be great! I cannot be the only one who needs to know how to do this. Thank you! You would normally set that option on the printer functions, File>Print>click Properties next to printer name. "Mayableu" wrote: &...

Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a webpage it returns an error stating that the the "item could not be created". Outlook 2000/Windows 2000 ...