Reply:

Pivot Table not pulling all fields or data
Hi All........ 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. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. 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? Hi Andrew, 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 body 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 database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx look at the comments section Russ -- 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. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <Matthews@discussions.microsoft.com> wrote in message news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com... > 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 news:11F6EC50-7351-4B84-A7BC-4322115C9B88@microsoft.com... > 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 Transaction Entry. ---------------- 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 NG. -- Vladimir <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? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) 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. code.mdb? 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 news:304D4935-F597-4BE9-A290-59C78A19AEBC@microsoft.com... |I am looking for programs wherein I can determine loan amortization You need Excel, not Access -- Len ______________________________________________________ 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 paragraph form: It is customer ID name and billing info but it is like a long series of address labels. 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. Thanks 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? Shen --- Message posted from http://www.ExcelForum.com/ Insert a helper column: =COUNTIF(A1:A9999,A1) (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"?> <CustomWeightEntries xmlns="http//schemas.microsoft.com/2005/CustomWeight"> <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. -- Thanks, Mark Use this --- =Date() -- KARL DEWEY Build a little - Test a little "Mark K" wrote: > I had a database in Access ...

Outlook 20003 stopped working
Hi, 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 ISP issue. 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 -- sonik ----------------------------------------------------------------------- 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. Sub CheckOrder() ' Application.CommandBars("Formula Auditing").Visible = True ActiveSheet.CircleInvalid Sheets("Configuration").CircleInvalid Sheets("Parts_TakeOff").CircleInvalid MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) & " Configuration and Parts_TakeOff Sheets") End Sub 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
Hi there, 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 m_graph.PrintGraph(CDC *pDC) 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 dialog? 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
jonbon wrote: <nothing> 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 the answer: http://www.slipstick.com/addins/services/online.htm which Google would have told you with 6.5 million hits in 0.43 secs. http://www.slipstick.com/addins/services/online.htm#aol -- 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...