how to persist pivot chart data
I have two worksheets: one sheet to do scratch work, and one to contain the
final product. I do the following:
1. Make a filter selection on the scratch sheet and copy the resulting pivot
table and pivot chart to the final sheet.
2. Make another filter selection on the scratch seet and copy the resulting
pivot table and pivot chart to the final sheet. ( I actually do many
iterations of this.)
Unfortunately, when I make another filter selection in the pivot table on
the scratch sheet and copy the table to the final sheet, the first pivot
chart on the final sheet reflects the results...Sort data by formatting
Is there any way to sort rows of data depending on their background color?
Like I have around 1000 mixed up rows of 5 colors (e.g. yellow, red, green,
violet, blue), and they are arranged in no specific order i.e first 2 yellow
rows, then 1 red, 4 blue, then again 3 yellow, and 3 blue ...so on.
I just want to arrange them in block of Colors like All Blue Rows, All
Yellow Rows etc.
Could it arrange using VBA or Excel?
for some ideas
"Murtaza" <NoEmail@NoEmail> wrote in message
news:OVD5bWWKFHA.147...Collecting Data via Email (InfoPath error)
I used the "Collecting Data via email" feature in Access 2007 and chose the
InfoPath option. The first time I opened the form in Outlook, it worked
fine. Then I went back to Access to tweak the table a little bit and used
the "Collecting Data via email" feature again. This time when I tried to
open the form in Outlook I received the following error:
"InfoPath cannot create a new, blank form.
InfoPath cannot open the form. To fix this problem, contact your system
I then clicked on the show details:
"InfoPath cannot open t...adding SBS2008 other email domain and making it default
How to add an additional email domain and make it default for Exchange 2007?
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
"Ronald" <email@example.com> wrote in message
> How to add an additional email domain and make it default for Exchange
We have a dedicated group for SBS...Data Validation Lookup List from Another File
Without duplicating the cell contents in the current spreadsheet (call
it Template), is there anyway to have a dropdown list of items
(starting in cell T38 and going down to T45) from another file
([Price_List.xls]License_Only!C2 to C whatever row which will change).
Then, when the item is selected from the list in T38, lookup the cell
to the left in row D of Price_List.xls and put it in S38.
The reason I don't want to duplicate the cell contents in the current
spreadsheet is because the file will be way too large to deal with.
I hope that explains it well enough
Thanks for any he...HELP- Copy a Data Series to Other Graphs? #3
I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs.
When I add a new data series to one graph, it is defined by 3 values
(Name, X Value and Y Value)
If I want to add this data series to 7 or 8 add'l graphs, I know that
I can copy/paste these 3 values to each of them.
Is there a simpler way to accomplish this?
...workplace default pane default tab
Strange as it may seem, some users cannot find "Default tab" and
"Default pane" to customize in the General tab of the Workplace (either
in Client or Web Access).
Even those who already used it, do no find it anymore.
How can this be achieved (customization / programming)?
Thanks a lot.
I have a spreadsheet that will require the end user to enter data in certain
cells. How can I setup the spreadsheet so that the user cannot close the
sheet until they have entered the data? Thank you in advance.
You can use this in the BeforeClose event in the thisworkbook module
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Application.WorksheetFunction.CountA(Sheets("Sheet1") _
.Range("A1:a10")) < 10 Then
MsgBox "You must fill in all the cells"
Cancel = True
Regards Ron de Bruin
(Win XP Pro SP-...Form defaults
I have a button on a form that disables and rearranges controls.
I think I went into design view it it pressed and that control
arrangement became the default.
I cannot change it back though. I tried clicking the button twice and
everything goes back to how it should be in form view. Then when I go
to design mode everything goes to the wrong defaults.
I hope that makes sense.
Thanks for your help.
...help with entering data into Investment Accounts
I'm quite confused on how I should enter data into my Investment Account (a
mutual fund account).
Suppose I start from the beginning: I put $5000 into the account and buy
some FundA and FundB. What kind of transaction are these, are they "buy" or
"add shares"? Secondly, if I later transfer/switch from one fund to the
other, are they "sell... buy" or "remove shares... add shares". (There
isn't a "switch" transaction type). Finally, if I sell some funds and
transfer the money out of the fund account, how do I do this? Use t...Column format when merging Excel data to Word labels
I have a four column Excel spreadsheet which I have Mail Merged into Word to
One of the columns in Excel contains a list of four digit numbers. Some of
those numbers begin with a zero.
When I have merged the data into Word labels, the four digit numbers
starting with a zero have the zero missing.
I have tried all sorts of number formats in Excel but can't get the zeros to
stay there when merged to Word.
Can anyone help???? I'm using Office 2003.
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Wo...Default Catagory
Is ther a way in Outlook 2002 and 2003 to set a default catagory to all new
Calendar items when they are created i.e. "Work" and then add any others you
Also can you add a catogory to all the existing items in the calendar again
"Work" in one go without destorying any existing catogories?
...Aggregating data for a chart
Hello. I wonder if someone can help me. I want to create a bar chart for a
stock but the raw data I have is "price" and "time" and I need to aggregate
that into high, low close format. The high and low seems simple enough - I
created a pivot table and used min and max for each time interval. The part
I'm having trouble with is getting the "close" (which is the last price in
any given time interval) number for each time interval. It seems like the
solution is on the tip of my tongue but I can't seem to get it out. Any help
is most appreciated!
...How to retrive/store data in UTF-16 format
Hi all ,
I am getting some problem related to storing & retriving UTF-16 data.
Actually i have a data in uncode character & i want to use that in my
program in VC. I am considering that the data is in UTF-16.& in that
format i want to store.
The question is ill-formed. "I am getting some problems" is not a meaningful description.
Unless we know *what;* these "problems" are, there is no hope of answering your question.
The problems will arise once you go above character value 65535, where you now have to use
"surrogates". Surrogates ...Change default outlook calendar
I just went from outlook 2002 to outlook 2003 pro.
I now have a default calendar that I would like to delete
because of all of its errors (duplicates, etc.) and
replace it with a clean copy of an alternative calendar.
David <firstname.lastname@example.org> wrote:
> I just went from outlook 2002 to outlook 2003 pro.
> I now have a default calendar that I would like to delete
> because of all of its errors (duplicates, etc.) and
> replace it with a clean copy of an alternative calendar.
Create a new PST and set it to be your default delivery locat...Fixed Assets
Doesn't Fixed Asset Management have a solution for printing the information
for the Form 4562 and Form 4797 right from the FA system? Other packages
offer this to print or output in PDF directly from the Fixed Asset system.
Is there any third-parties out there that offer a add-on solution?
...data table problem
I have created a data table that looks like something below and th
column input cell links to a cell with 8.25%
7.50% 1,183.57 91,042.82
8.25% 1,183.57 91,042.82
8.00% 1,183.57 91,042.82
As you can see the table is the same and this is wrong. I have don
this over and over again with the same result. Can someone tell me wha
I did wrong. The colums below the bold heading should be different t
the headings and I dont know what I did wrong thanks for your help
---------------------------------------------------------...Change default font and size for comments?
Does anyone know how to do the above?
Right-click on the desktop > Properties
Appearance tab > Item dropdown, select Tooltip
Choose a font Size, click OK
You'll see that you can change the font and colour as well.
Norman Harker MVP (Excel)
To change the default font size (this will also change the settings for
tooltips in Excel and other programs):
Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font ...Footer defaults
I use a consistent protocol for footers on my reports but would like those
footers to exist in every file I create. Is there some way to make them the
create a new workbook with this footer and save this as a template
"Joe S." <JoeS@discussions.microsoft.com> schrieb im Newsbeitrag
> I use a consistent protocol for footers on my reports but would like
> footers to exist in every file I create. Is there some way to make
them th...Default organization not default
I changed my default organization of CRM. However when opening the default
server URL. Still the old default organization is opened.
Resetting IIS, clearing the Internet Explorer cache en even rebooting the
server does not help.
Does someone have more ideas??
try to disable the other organization and keep the only one . access
it with default and post us if you get the error.
I disabled all the organizations except the one I that needs to be de
default. Opening CRM with the default URL the following error is displa...email default
I set up my outlook as my email default (the same as in outlook 2000). The
difference in 2007 is that whenever I sign on to outlook, it totally empties
my aol mail box. With 2000, I got my mail but it also stayed in aol. How
can I change this?
Change the Advanced tab on your Account Properties to leave the messages on
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
"Fran" <Fran@discussions.microsoft.com> wrote in message
news:...Convert Data to columns heading
Product | Date | Sales
A | Jan94 | 200
A | Feb94 | 300
A | Mar94 | 400
A | Apr94 | 500
A | May94 | 600
A | Jun94 | 700
A | Jul94 | 800
A | Aug94 | 200
A | Sep94 | 300
A | Oct94 | 400
A | Nov94 | 500
A | Dec94 | 600
B | Jan94 | 200
B | Feb94 | 300
B | Mar94 | 400
B | Apr94 | 500
B | May94 | 600
B | Jun94 | 700
B | Jul94 | 800
B | Aug94 | 200
B | Sep94 | 300
B | Oct94 | 400
B | Nov94 | 500
B | Dec94 | 600
How can I convert it to:
Product | Jan94 | Feb94 | Mar94 | Apr94 | May94| Jun94 | Jul94......
----------------------------------------------------------------...Access asking for extra data in reports.
I have a report which keeps prompting me to enter data which used to be in
the report but I have since deleted....how can I get it to stop asking me for
There could be a filter set in the properties of the report. Check to see if
no filter is set. Furthermore you can have some calculated fields or
referring fields to non-existing fields (so check the fields on your report
to see if there are any refs)
Finally if you have any subtotals done with the previous data see if the
total fields are deleted...
Just my thoughts...
&g...Resize 2 Forms at Once Like HTML Frames
I'm envisioning an application with 2 forms filling up the screen, one
on top of the other. The user could drag in the middle to resize both
simultaneously just as you would a website with 2 frames. How can I do
-- Thanks for helping. Paul C
Put code in the Resize events of both forms, referring to each other. If the
Width of FormA decreases by a certain amount, increase the Width of FormB
and so on.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
<email@example.com> wrote in message
news:firstname.lastname@example.org...export data between spreadsheets
how do I setup an excel file that each time when I enter data in one
spreadsheet it will export to another excel file in the same column of
Example: if each time data enter in one spreadsheet column A of row 1 it
will export this data to another spreadsheet column B of row 1,2,3... and so
See the last example on the page
Regards Ron de Bruin
"scott" <email@example.com> wrote in message news:08B9...