Pivot link changes...why?

I have three pivot tables in a workbook, each on a different sheet. I
linked two tables (A, B) to the third table (C), which is externally
linked to a database; however, at some point, table (A)'s link to (C)
breaks and it (A) relinks to the external source that (C) is linked to.

What might be causing this link change?

PS: I link (A) and (B) to (C) using the pivot wizard..."link to another
pivot".

0
1/26/2005 7:59:35 PM
excel 39879 articles. 2 followers. Follow

0 Replies
315 Views

Similar Articles

[PageSpeed] 2

Reply:

Similar Artilces:

Win7 Social and Other Forums Links
Someone, the MVP, posted links for Subject. I've xferred to Win7 and I think my references are now lost. Could someone repeat them? http://social.answers.microsoft.com/Forums/en-US/group/WindowsAnswers "W. eWatson" <wolftracks@invalid.com> wrote in message news:hlud4d$5kk$1@news.eternal-september.org... > Someone, the MVP, posted links for Subject. I've xferred to Win7 and I > think my references are now lost. Could someone repeat them? http://social.answers.microsoft.com/Forums/en-US/category/windows7 W. eWatson wrote: > Someone, the MV...

Email address fields should not be formatted as a link
Email address fields in CRM are formatted in blue and underlined. This normally indicates a link in CRM. However, when users click on an email address, nothing happens. This does not meet users expectations. Email fields should either not be formatted as links or the field should perform an action when clicked on, like open up a new email in outlook pre-filled with the email address. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message...

Calculated Items in Pivot Tables #2
Dear all, I am new to excel pivot table and I would like to ask you all a question regarding the calculated items/fields in pivot table. I am making a pivot table whose data source is shown below: Team Person Amount_Sold Price_each Paper A 50 35 Paper D 60 25 Pen D 500 4 Desk C 20 400 Desk A 10 700 Pen B 700 3.5 Clip B 500 2.5 Clip C 600 2 Desk B 15 600 I am thinking if it is a way to ad...

Automatically send email message when folder contents have changed.
Hoping someone can help. We have a UNIX server on our network and an Exchange 2003 server. Ideally we would like to have the Exchange server send an email to a group of users when a new file gets added to a shared folder on the UNIX box. The UNIX box is running VisionFS and we can see the shared folder in our Windows environment. Ideally I would like to have the Exchange server send a message without having to dedicate a PC running Outlook and a plug-in to the task but will do so if necessary. Any thoughts would be appreciated... Script it, schedule it to run on any member server (good i...

Linking Axes Max & Mins to source chart
Hi All, I've pasted a chart from one workbook into another, the data is sourced from the original workbook. I would like for the chart to be linked from the original chart though. As in, I want to be able to make changes to the formatting (particularly the scale) of the original chart and have that appear in the chart in the second chart. Basically, I want the charts to be linked. This is part of a process that will need to be repeated hundreds of times so pasting in a picture each time the chart changes is an option I'm trying to avoid. Any thoughts, ideas, or suggestions (or sta...

"Auto-change" button
Hello... How to do auto-change button e.g. I have button " Start" and when I press it, "Start" has to change to "Stop" and when I press "Stop", it has to change to "Start". "Start" and "Stop" must be connected with different functions. >How to do auto-change button e.g. >I have button " Start" and when I press it, "Start" has to change to >"Stop" and >when I press "Stop", it has to change to "Start". >"Start" and "Stop" must be connected ...

Prevent "Updated:" Prefix on Changed Meetings
Does anyone know how I can stop the "Updated:" prefix from being added by Outlook 2003 when someone in my office sends me an update to a meeting? AFAIK, you can't remove that designation. -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. How to ask a question: http://support.microsoft.com/KB/555375 After furious head scratching, Don asked: | Does anyone know how I can stop the "Updated:" prefix from being | added by Outlook 2003 when someone in my office sends me an update to | a meeting? ...

Pivot Tables
How do I remove the subtotal groupings within a pivot table and only display the final totals. -- Rose Have you tired to group by on a constant, something like (in SQL view): TRANSFROM SUM(somefield) SELECT "All" FROM tableName GROUP BY "All" PIVOT someFieldOrExpression Vanderghast, Access MVP "Rose" <Rose@discussions.microsoft.com> wrote in message news:523C8A87-0E76-4357-B232-809A344593BF@microsoft.com... > How do I remove the subtotal groupings within a pivot table and only > display > the final totals. > -- > Rose ...

outlook changing event duration
All of my one day events have been doubled in size. I don't know what causes this. I go in and try to fix it, but then it happens again! Why is this happenning? I first noticed it after changing my time due to DST. Thanks. Paulette guillorypr wrote: > All of my one day events have been doubled in size. I don't know what > causes this. I go in and try to fix it, but then it happens again! > Why is this happenning? > I first noticed it after changing my time due > to DST. Thanks. That's why it happened. http://support.microsoft.com/kb/197718/EN-US/> (applies ...

Have templates changed in Word 2007?
Our office has recently upgraded to Office 2007. Previously when opening a template (in 2003) it would open and be named as, for example "Document1" rather than the name of the template. So it would be opening a clean copy of the template rather than the template itself. Now in 2007, our Word templates seem to open either as a read only versions of the template or the template itself. How can I get our templates to behave as they did in 2003? Thank you -- Brendan Adelaide, Australia When you "open" a template, you're opening it for editing. To create...

Why won't my Pivot Tables recognise new data?
Hi for some reason I cannot get my pivot tables to recognise that new dat has been added to the worksheet. When I delete the old data and pu new data in (I've tried adding 3000 records) the pivot tabl disappeares and appears to be asking me to reconstruct it. I' refering in this instance to the "Most Recent Activity Date worksheet. Please note I'm an Excel beginner - almost all of the construction o this workbook has been down to a few kind souls out there (specia mention to I.Savell). Any help much appreciated. I've attached the file for anyone who cares to have a s...

How do I make a section link to certain sections
How di I make section link to certain sections Link in what way? Note that if you are referring to a header (or footer), it can only be linked to its "neighbor" in the preceding section. But you can bookmark text that you want to duplicate and then insert a cross-reference to the bookmark into your header (footer). -- Stefan Blom Microsoft Word MVP (Message posted via NNTP) "Delicate" <Delicate@discussions.microsoft.com> wrote in message news:30534AB8-1830-4D7C-A0C0-C27786434540@microsoft.com... > How di I make section link to certain se...

Changing the sender name in email
We have a user whose email address appears as mike <mike@pierxx.com> when sending mail externally and appears as mike when sending it internally. We are using exchange 5.5, sp4. We want the sender's name to appear internally and externally as (e.g.) Mike Firet (I understand that the external email will still have the suffix of the sender's email address of <mike@pierxx.com>. which is fine.) I have modified every tab I find that is remotely pertinant w/o success, and have tried it on a exchange 2000 test bench as well. Can this be done. Thanks in advance. (TIA ...

Change User Name
How do you change the user name in outlook from example john@ibm.com to John Smith? Go into the properties for your mail account and change it there. If you need help with that, we'll need to know your Outlook version. -- Jocelyn Fiorello MVP - Outlook *** Replies sent to my e-mail address will probably not be answered -- please reply only to the newsgroup to preserve the message thread. *** In news:015d01c39bf6$969cbba0$a301280a@phx.gbl, Melanie wrote: > How do you change the user name in outlook from example > john@ibm.com to John Smith? ...

Why formula doesn't change on column insertion?
Hello: I know I will feel stupid when I hear the answer, but... If I have a formula ( =average(a1:a5) ), and I insert a new column, the formula, being relative, changes to ( =average(a1:a6) ). This works fine in a test. BUT I have a working spreadsheet in which inserting a column does *not* change the relative formula. Why? I can't see anything different in my working spreadsheet... -- Fred Boer Never mind - resolved. -- Fred Boer "Fred Boer" <fredboer1@NOyahooSPAM.com> wrote in message news:uin$VfrDIHA.5160@TK2MSFTNGP05.phx.gbl... > Hello: > >...

Need ideas for a changing sort key
I need to create a form where someone asks tasks which have to be accomplished in order, the dates being irrelevant, though it will be tracked. What is the best way to create a field that will prioritize these in order? There will be many instances where a task is inserted or removed from the list. If I have steps 1 through 5 for example, and need to add one between 2 and 3, I don't want to have to renumber 3 through 5 as 4 through 6. It's a tool to train new employees how to do their job, the series of tasks will change from project to project so I'd like to create a ma...

multiple or changing colours in a data table on an excel chart fo.
We are trying to have the "negative" numbers in a data table (under the chart) show in red, like the data series, but seem unable to alter the format unless it is for all data. (we're trying to highlight or bring attention to the negative variances) The data labels will follow the excel font's but the data table does not appear to. Any suggestions? Kerri, Unfortunately the formatting options for data tables are fairly limited. As a result, it's not possible to apply different font formatting to different cells or rows within any one data table. If you are usi...

Excel-Linking Cells & Formatting
Morning everyone, I think my question has been addressed in a couple of different ways, but I want to be exactly sure. I have combinations of formulas that display different text paragraphs in a single cell depending on the input. My problem is that the text that is displayed is not retaining its formatting from where it is originally entered (I.e., bold, underline, etc.). Also I am using text wrap, but the rows are not re-sizing to compensate for the different lengths of the resulting text. Anyone know of a way around these two problems? Thanks in advance, Nomad Hi formulas can't ...

If check box changes
Access 2003 On my subform I have 3 checkboxes format Yes\No BBAll - control source BBAll default Yes BB1 - control source BB1 default No BB2 - control source BB2 default No and 2 textboxes TextBB1 - control source =DLookUp("[BB1]","[t000Facts]","[UnitID] =" & [UnitNo]) TextBB2 - control source =DLookUp("[BB2]","[t000Facts]","[UnitID] =" & [UnitNo]) If TextBB1 is null then BB1.enabled=false If TextBB2 is null then BB2.enabled=false this means if TextBB1 is empty then the BB1 checkbox selection is disabled(s...

Quick Links in Customize HomePage can't get Fixed Asset reports
When you click on Customize This Page. Quick Links, Add, Microsoft Dynamics GP window, Reports, Fixed Assets, there is nothing to add. There doesn't seem to be a way to get the FA reports on the home page. We can use the shortcut bar, however. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Ag...

Combo No Change and After Update Event
I have a combo box where the After Update event of the combo box is used to reset another control on the form to Null. Sometimes a user will want to reconsider his/her choice in the combo box and make a different selection from what was there before. This is OK as it triggers the resetting of the other control to Null. My problem is - sometimes the user will revisit the combo box and explore the other possible selections in the combo but eventually settles back on the original selection with the result that the After Update event is triggered and the other control value is scrubbed, which i...

Who is changing my #$@# mouse cursor??
I wrote a custom control. On portions of this custom control, I change the mouse cursor to the hand cursor. I do this by handling the WM_SETCURSOR message and calling SetCursor(). All appeared to be working fine til QA happened to notice that if they hold down ALT-Z (an invalid menu accelerator that just causes the OS to beep) while mousing over my control, it sometimes flashes the normal arrow cursor when it should be showing the hand cursor. I can't for the life of me figure out who is changing this... these are the steps I've taken so far: 1) check, double checked and triple...

linking to stock quotes
Does anyone out there know how to link a cell to a stock quote and automatically update the quote whenever the sheet is opened? >-----Original Message----- >Does anyone out there know how to link a cell to a stock >quote and automatically update the quote whenever the sheet >is opened? >. >I'm putting this in to push this question back to the top. If there is someone monitoring this group, please let me no if there is not a way to like a cell with a current stock price. I don't want to spend two more hours trying to figure out something that can't be done. CA...

Change format of one cell based on another
Hi. How do I change the format of one cell eg make the fill colour of cell A1 yellow, based on another eg if cell A4 is greater than 100%? Thanks. format...conditional formattin -- Message posted from http://www.ExcelForum.com Thanks, but how do you reference another cell? >-----Original Message----- >format...conditional formatting > > >--- >Message posted from http://www.ExcelForum.com/ > >. > in conditional formatting under condition 1 select "formula is" and the put in the formula you wan -- Message posted from http://www.ExcelForum.com &q...

Unable to access folders after changing mail server
Hi, I am using MS outlook 2003(win xp) with lotus notes connector to access my office mails. Everything was working properly untill I changed my mail server to a new one. The nsf file was also copied to the new domino server. But after this my outlook stopped working. It shows below message while trying to access inbox. "Cannot start Microsoft Office Outlook, Unable to open the Outlook window. The set of folders could not be opened. The server is not available. Contact your administrator if this condition persists." I deleted and recreated my outlook profile,but the problem still...