Pivot Table not pulling all fields or data
Without getting too verbose, I have a 900 row by 26 column database I am
applying a Pivot Table to. The code seems to run fine, but it is not
returning some of the fields, and of course the related data. I have tried
reformatting the entire columns I am pulling from but no joy......however,
when I reformat an errant cell from General to TEXT, that row comes
in........and/or, if I change the value in one of the missing cells, it will
bring that row in. The code runs fine, and was mostly derived by recording
a macro in XL2k, but the data cannot be trusted becau...How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in
Collumn C. Right now Both are defined by rows 4 to 114.
I would like to be able to have the chart automatically redefine itself so
if I put a value in C115 the chart would automaticaly set Y value range to be
C4:C115 eithout having to manually define chart. Is this possible? If so
how? I've tried OFFSET bu so far no luck.
If you turn your data cells into a List, or Table in xl2007, the chart will
The named range approach will work if you set up the names correctly.
See here for more info...Deleting Actual Work Deletes Protected Actuals
I am running Project Server 2007 with SP2 and Feb 2010 CU. I am using
the Task Setting Restrict Updates to PWA. However, when I delete all
the Actual Work for a resource in Project Pro, clicking Sync to
Protected Actuals does nothing. In addition, all the hours entered
via My Tasks of PWA are gone.
Has anyone else experienced this bug?
Is your Project Professional client also running SP2 + CU? I have seen what
you mentioned but it was a bug that affected SP1 and I'm pretty sure it was
fixed before SP2...
Specifically the bug I recall was that it was possibl...Outlook and message rules- can't get one to work?
I have set up message rules to divert mail from my inbox to various sub
folders or new folders. I use these:-
Check messages when they arrive\ from people or distribution list \ with
specific words in the senders address \ with specific words in the subject or
Now the problem is that some of the messages are recieved from people in my
address book and when they send a message sometimes their name and address is
in the 'from' and other times it is just their name and so the ones with just
their name do not get moved across to the folder I want. I have added their
name or...Exchange data backup
I'm worried emails backup of the small office.
Does SBS2008 Exchange server has a direct backup capability of whole mail
How to backup every night Emails from server to external harddisk?
Does Exchange server needs to be stopped before backup?
SBS2008 Takes care of it.
look at the comments section
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Seco...Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save
records, where as the system administrator is able to save the same
information. Please advice on this error, what has to be done.
I have disabled the windows user ID of the Database owner. Thinking of this
made Dynasa as the DBO.
Database is having enough free space available.
How big is the company database? Is it over 10GB?
"Matthews" <Matthews@discussions.microsoft.com> wrote in message
> GP Ver 6.0. Recently I...Using Outlook 2003 in Windows 7
I have a valid version of Outlook 2003 that I am using in Windows 7 that has
been properly activated. However, every time I open it in Windows 7 I am
asked to accept the Microsoft End User Agreement, which is annoying since I
accept it every time (actually this happens every time I open an Office 2003
product). Is there someway to deactivate this request?
Thx for the help.
"Barry" <Barry@discussions.microsoft.com> wrote in message
> I have a valid version of Outlook 2003 that I am using in Win...restrict amount received in Sales Trx Entry window
I would like to suggest for a way to restrict users from entering amount
higher than the actual amount of invoice in the Sales Transaction Entry
window. This will restrict the Amount Received field in the Sales
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 Agree" in the m...How to use the countif() function to count items in a table
I have a table contains multple columns of info as shown
in the below
AcctID ProjectName PMName Phase Status
EIG Project 1 Wellie Initiation New
MLI Project 2 John Develop Active
EIG Project 11 Wellie Qualify Active
EIG Project UUU John Design InActive
MLI Project XX Carol Deployment Completed
MLI Project YYY Carol Design Active
I'd like to use the countif() function to complete the
following metric such that I know how many projects for
each status for each AcctID.
EIG ...Auto-Calculation Not Working
I have a workbook in Excel 2003 that I update frequently. Occasionally, the
workbook will not update formula results after a variable or data has been
changed. Auto-calc is selected on each sheet. Pressing F9 does not do
anything. I have to press F2 on each cell and then press <enter> to get the
cells to update individually (quite a chore). I have not observed any common
issues when this occurs. Does anyone know a fix for this?
Try pressing CTRL+ALT+F9. If that doesn't work, you can always use search and
replace to search for an equal sign and replace it with an equaL sig...Corrupt TCP segments using CSocket
I am developing a simple streaming video application. I am using TCP
with the CSocket MFC class and I have a thread the writes the data for
each frame in a separate Write(). The app works fine for about 2
minutes of "playing" the video, but after some time (2-15) minutes I am
getting segments with invalid TCP checksum (observing the traffic in
etherreal). If I retry the connection from the client it doesn't
recover. It recovers when I restart the server. Any ideas?
Ask your question additionally at microsoft.public.win32.programmer.networks
<vladimir.rale...cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data
sheet that is being refreshed. 5878 is the correct number of rows and 5824
is not. I can find and replace in my formulas to correct the problem, but it
does it each time the data is refreshed. Any suggestions as to why?
I gave you the INDIRECT option y'day, but received no feedback from you in
that thread. Looks like you're more interested in knowing why? One simple
hunc...Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms,
modules, and logic) used to CRUD the data in the tables.
1) Is there any way to separate the database from the code into separate
files, eg. the db is mydata.mdb and the 'code is in a separate file, eg.
2) Say you have v1.0 of an app and the tables and attributes are populated
with data. You then go and build v2.0 of the app, adding tables and columns
to what already existed in v1.0, and perhaps moving some of the v1.0
attributes into different tables. What is the recommended way to
unload/reloa...Outlook 2002 was working fine but now will not reply, get relay er
Outlook 2002 was working fine. Switched to DSL and now we can not reply to
some addresses. Using MSN Premium for an ISP. Any help would be
appreciated. Qwest techs will not support Outlook.
...whihc microsoft office can i use to determine loan amortization
I am looking for programs wherein I can determine loan amortization
"Justin Reyes" <JustinReyes@discussions.microsoft.com> wrote in message
|I am looking for programs wherein I can determine loan amortization
You need Excel, not Access
remove nothing for valid email address.
...Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in
It is customer ID name and billing info but it is like a long series of
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...97: How can I find duplicate entries in a column?
Hello and thanks in advance for any help. This is a very basic question
from an even more basic user. I have a spread sheet with a long list of
ID numbers for skips. Sometimes duplicate numbers arise from paper work
from elsewhere and I get a false total of skips in hand. How can I
organise that column to highlight a duplicate entry please?
Message posted from http://www.ExcelForum.com/
Insert a helper column:
(adjust the range to suit.)
then the formulas that evaluate to more than 1 will be duplicated.
Chip Pearson has some other techniques at:
http://ww...UCE content filter not working
We are running Exchange 2003 with SP2 and I'm trying to get the uce content
filter to work. Below is the xml file which I do save as unicode.
I can't get the Inside Elderhealth part to work. I restarted the SMPT server
in Exchange System Center and the SMTP service from Services.
<?xml version="1.0" encoding="UTF-16"?>
<CustomWeightEntry Type="Both" Change="9" Text="viagra"/>
<CustomWeightEntry Type="Both" Change=...Access 2007 date function not working
I had a database in Access 2003 that I imported into 2007 and all works well
except the date function in Reports. I have tried to go into reports and
repair by adding a date field, but when I try to open the report and error
box comes up asks for update parameter value for the date. The currrent date
will not display in my reports, just (#name?) is in the date field. You would
think trying to put the current date in a report would be easy.
Use this ---
Build a little - Test a little
"Mark K" wrote:
> I had a database in Access ...Outlook 20003 stopped working
As of 3 days ago, my outlook suddenly stopped working.
Nothing had changed on my computer during these days.
This probolems happens on 2 computers I have here, bit
have the same setup and same hardware.
1. My laptop still works, I can login to all my accounts
and get emails into outlook and outlook express, I can
also login to msn messenger. So therefrore this is not an
2. I dont have a bad header or big attachement on any of
the emails I am trying to download right now. I have just
send some basic plain text messeges test messages. with
outlook its starts to downl...Display comments as data #2
thanks a lot , this worked exactly as required, the comment go
converted to data
Now just one more thing . is the vice versa possible i.e if i have dat
in column A can it be shown as comment in column B.
the reason i need this is bcos i am shifting some data with thei
comments to MS access(Hence the need to convert omments to data)
processing them and again converting them to excel (the need to conver
data back to comments
sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...Count invalid data entries
I am using the following macro to identify invalid data entries in
cells with data validation applied.
' Application.CommandBars("Formula Auditing").Visible = True
MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) &
" Configuration and Parts_TakeOff Sheets")
Is there a way to count the number of invalid data entries (red
circles) and write the number to a particular ce...Print Preview using CPreviewDC
I have a problem trying to implement a print preview
function. Yet the printing itself is no problem.
I have this chart control with a method
which outputs the data to the CDC object.
Now I want to do Print Preview similarly using the
CPreviewDC class mentioned in the MSDN Documentation
instead of the CDC class.
How do I setup the CPreviewDC object without a print
And after I have printed the content into the CDC class
how do I display the print preview?
...how do i configure outlook to use my aol email account
PLEASE write your question in the body of the post and NOT just the subject
Have a look here: http://dts-l.org/goodpost.htm
which Google would have told you with 6.5 million hits in 0.43 secs.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook Tips: http://www.outlook-t...using min max
We want to start using min max to help with order processing. Do we need to
use order point qty or order up to level with the min max? We are using GP
v10 and new to GP. Do we need to set the order policy before using min max?
Is there a good source on how to set the min max in GP10?
the Purchase Order Processing pdf in the GP Documentation folder is pretty
good. The values are all interelated. What we did here was create a dummy
part and played with it. You can leave the Items order policy as 'Not
Planned'. We wanted to set up to use PO generation but our purchasing g...