Pivot Table Updates Issue
My Data had a coloum containing stuff like
I built a bunch of pivot tables on this data. Then I changed the data
and performed a Refresh Data.
Now, on the filter pulldowns on any of the Pivot tables, I see
The first three option no longer exist in any of the data, and I do not
want them in the list. How to fix this problem without recreating and
reformatting 38 seperate Pivot table...Listbox and sheet updating issue
I need your assistance with a problem I have with a listbox.
I have a sheet containing a range "Reporting_Periods" which has col(1) = a
number 1 to 15 (Period), and Col(2) a StartDate and col(3) an EndDate.
I have a userform with one listbox, and 3 textboxes - Period, Startdate,
Enddate. The users may change the dates in an existing Period, and if the
click in the blank line under the last populated row in the listbox, they
can create a new Period.
The listbox is populated at Userform_Initialize which sets the row source
and the bound column (Period).
Everything works O...Pivot Table formating issues:
I have downloaded data from SQL Server.
I want it in a pivot table sorted by last name.
When I create the pivot, it gives me columns and rows
like below. It does not repeat the last name. It groups
on the last name. I don't want it like that. I want to
get the last name repeated in every row. I can't find a
setting to change this. The data is correct in the query
from SQL server.
I want it like
Any help on this is greatly appreciated.
Can you convert the pivo...Several issues while applying Exchange DST update
I am having some similiar issues that others are having when trying to
use the Exchange mailbox tool. When I run the GrantMailPermissions vbs
script it only grants me permission to about half of my mailboxes. I
have tried to go in manually and grant the necessary rights, but I
still get the same error message when running the Update tool,
Error Processing Mailbox: legacyDN serevrname - 0x80040115
I think it's something to do with the permissions on those user
accounts, but I'm not sure what to do. The tool does work just fine
for about 220 out of 500 mailboxes.
I have done the follow...Smartlist/View issue with Intercompany Dist Accounts
I am trying to create a SQL view for smarlist and I am haveing some issues.
The view I want to create is basically a Payables view showing the document
amount and the distribution accounts and amounts going to each. The problem
is that when I link the Account master [account inderx] field to the
distribution account index field the itner-company accoutns are not correct.
Does any body have any ideas where I am going wrong? View code below:
dbo....RM QUick Detail Aged Trial Balance Modification Issue
I want to modify this report to not show detail from the 'current' period so
that it is more of an alert for salespeople and much shorter... (assuming
most people pay on time)..
Anyhow.. is this possible?
I figured the only way to do it would be to somehow link to RM00103
agperamt_1 and restrict on that basis. I am able to add this field to the
report, but not able to figure out how to restrict the detail by this field.
Is there a reason that you aren't using the aged trial balance with options?
"LesWright" <LesWright@discussions.microsoft.com&...Need to recall an invoice
Hullo. We have a user who accidentally deleted an invoice and would
like it recalled. Is there a simple fix for this or do I need to call
in some big guns?
I take it the invoice was NOT posted? Was it transferred from an Order or
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
> Hullo. We have a user who accidentally deleted an invoice and would
> like it recalled. Is there a simple fix for thi...Couple more issues
1) My wife (W2008, Intel Mini 10.5.8) had the issue that a double-click
no longer selected a word in a Word doc. We checked by swapping the
mouse for another that it wasn't that ( although I took the mouse - a
Might Mouse - off for a wash and brushup as it wasn't scrolling either).
In the end she rebooted and it fixed it. We couldn't find a pref for
"double-click selects word" so any suggestions here would be appreciated.
2) I notice that if a W2008 doc doesn't have focus, mousing over and
scrolling (with a Mighty Mouse) doesn't work (this works in ...Excel 2007 Import Issue
Attempting to import a text file into excel.
I am trying to import the Exchange SMTP Service logs into Excel 2007 and I
get the problem found and Excel restarts everytime.
The same file imports into Excel 2003 with No problems.
A sample line from the file:
2007-02-26 05:02:49 184.108.40.206 mx3.mailserver.org SMTPSVC1 SERVERNAME
192.168.1.1 MAIL - +FROM:<firstname.lastname@example.org> 250 54 41 0 SMTP - - - -
I have an *.csv file and want to open the file in Excel. Some of the
data is large number and other lines have text that include + and minus
When the file is opened i...Sharepoint list using using Issue "Created at" in calculations
We are using SharePoint at work. I currently have a list that I use the
following Calculation to indicate how long an event have been open.
=DATEDIF(Date,"1/4/2010","d"), however I would like to key on the Item
“Created at” that is stored for each item. Does anyone know how to pint to
that within a calculation. The result would be it has been 15 days since a
list item was opened.
...Word Outlining Issues
When I'm outlining text in Word 2003, if I try to do something else in the
middle Word seems to take great offense.
For example I'm working on a procedure that is outlined 1.0, 1.1, 1.1.1
and somewhere in the process I decide to do a numbered, not outlined, list
Word fights me tooth and nail.
I've tried removing all formatting, and then starting the numbered list and
Word still wanted to format the list as outline numbered. Or when I insist
it moves the list way over to the right of the page.
Other times I've been unable to continue numbering, or unable to restar...2003 font and bar issues
1. Is it possible to change the size/color of the greyish font used for the
subject line of messages not yet read in the Inbox for Outlook 2003?
2. Is it possible to change the relative vertical size of the two bottom
elements in the Navigation Pane. In theory it is, I think, but I can't move
The answer to part 2 of my question is I found, that you can choose "see
fewer icons" and eventually line the whole bunch as small icons at the
bottom, which is quite attractive and useful: a feature of the Nav. Column I
didn't like was how little I could see of ...networkdays issue
This is my Q838 field: 3/3/2010 4:06:08 PM
This is my T838 field: 3/3/2010 8:22:42 PM
This is my function:
What I get is 16:06
what I would expect to get is 4 hours 16 minutes and 34 seconds
What did I do wrong in the function to get such a difference?
The *24 at the end is making the formula return a decimal so delete it and
then format the cell as time and you will get
4 hours 16 minutes and 34 seconds
=((NETWORKDAYS(Q838,T838)-1)*("10:00"-"01:0...isIconic issue again...
I'm trying to undestand every piece of code the vc wirard create. In
particular, I'm not able un understand when the function IsIconic()
became true in this piece of code:
// Centrare l'icona nel rettangolo client.
int cxIcon = GetSystemMetrics(SM_CXICON);
int cyIcon = GetSystemMetrics(SM_CYICON);
int x = (rect.Width() - cxIcon + 1) / 2;
int y = (rect.Height() - c...Windows 7 and Windows XP VM: disk drive issue
The problem: I've installed Win 7 pro (64 bit) and the Win XP virtual
machine (the one you have to download, not the "compatibility mode" included
with Win 7). The computer is an HP m9425f with three hard drives -- no idea
whether they are partitions of a single physical drive or separate. The
drives are, naturally, C, D, and E. The DVD drive is F.
The problem is that the Win XP VM can't see the D and E drives. It therefore
assigns letter D to the DVD -- and then complains because it can't find the
DVD drive. I've tried setting Win 7 to not tell the XP VM tha...MOREFUNC.XLL
I'd be very grateful if someone can help with this - tearing my hai
I have a charting application "pushing" data record by record (row b
row) directly into an Excel worksheet. There are no DDE statement
involved in Excel.
I need to get a snapshot of calculations at specific points in time
when a new record comes in. Unfortunately, Excel keeps o
re-calculating everything from scratch each time a new record/row come
in, overwriting previous results.
When a row is filled (say columns A-H) then calculations will be don
(in column I) based on calculation on this row and oth...Odd Issue
Exchange 2003 on native 2003 AD.
I am really baffled. I have a distribution group called school admin. It
has 2 users in it, Jodi and Mark. When someone (anyone) makes a calander
event and adds School Admin to the attendies, Jodi gets the request, Mark
does not. Here's the wierd part. Beth and Robyn, are not on the DL, are
not connected to that school. Beth get the invitation and whoever sent the
invite gets a NDR about Robyn.
I have deleted the DL and recreated it. I have looked at Jodi and Marks
deligation and it's clean. Where else can I look?
That ...OWA issue
I have come across a strange problem and I cannot find any documentation on
the Internet whatsoever. I am trying to use OWA on an Exchange 2003 server.
Everything works fine, I can do everything EXCEPT compose a new message or
reply to a message. I receive the error "! An unknown error happened" inside
of what would be the new message I am composing or replying to. This may be
related because it is this same machine, but when I click the log off button
I receive popup error that says "there has been an error removing
certificates from this workstation." I am not ru...Password Issue #4
I set up a money file on my laptop a few years ago and I originally assigned
a password to protect access to it. I subsequently took away the password
and can now access the the file on my laptop without the password.
I now have a new desktop and I want to transfer the file to it. The problem
is that when I seek to import or restore a backup made from my laptop it
looks for a password even though when I use money on my laptop no password is
required. As I have forgotten the original password I cannot import or
resore the file. Is there any way I can get round this problem
...Cellcore / Odd SIM Issue
We've got an interesting question here...! Normally using a few test
SIMs here, we've tried work fine connecting using GPRS. However with
some particular Vodafone Ireland SIMS, when the board boots, a magic
window appears called "Vodafone Services" containing items such as
"Top-Up", "Customer Service" and "Vodafone Offers". This I assume must
be from something stored in the SIM that causes CE to fire up this
window. This is an annoyance that we need to disable somehow?
I'm not too familiar with this but I think it looks li...CRM integration for GP: reinstall issue
When I uninstall and reinstall CRM integration for GP, I get a message that
"the user specified does not have all the required CRM privileges." The
Integration User in CRM is a system administrator, and the
domain\integrationuser account is a member of the domain admins group.
What other privileges should the account have? Did I uninstall incorrectly?
I believe the integration use has to have a role and a license assigned to
them in CRM (Admin role).
Presentations Direct - Office Equipment & Supplies
http://www.presentationsdirect.co...Outlook printing issue
First time poster.
I am running Microsoft Office 2007 and having issues with Outlook. I
periodically get a window popping up asking me to re-enter my password.
Thsi comes and goes every few weeks.
My issue today is more serious. When I open an email and then go to
print it, I get the print window and when I click on print my outlook
says it expereinced an error, shuts down and then re-opnes on its own.
My system gets updates automatically and I download then as they become
available. I am running Vista Home Premium SP2.
Thanks in advance.
Jame...price list issue
Is there a way to manually enter the Price Per Unit when adding a new
Opportunity Product? There is no set price for the product we are dealing
with. Picking the product from a list is no problem, I just don't want the
prices to be a set number. Right now the PPU is filled in based on quantity
and the price that is entered in the product list.
No.You cannot enter Amount for a rpoduct in the Opportunity stage but
definitely during the Quote, Order stage, you can manually add the price for
an existing or a new product.
You'll have to get this customized if it is Important i...Office 2007 and Windows 7 Multilingual Issue
Need some help setting up multilingual for Office 2007. Here's what I have:
OS: Windowns 2007 Enterprise
Office: Office 2007 Pro w/ SP2
Language Pack: Install several language packs thru the Windows 7 Update
So, here's the thing. I can't get the UI in the office apps (WOrd, Excel,
etc) to display the language I want. For example, I want the ribbon to
display in Chinese. Reading thru the documentations from Microsoft, it saids
I need to select the laugage in the "Display Language" tab on All Programs ->
Microsoft Office -> M...sync issues problem outlook 2007
Running exchange 2007. In outlook 2007 I am receiving this in my sync
issues folder. It doesn't appear to be the case for everyone.
Microsoft Exchange offline address book
15:07:16 Not downloading Offline address book files. A server (URL)
could not be located.
I have the same Problem and need an urgent help bacause this is affecting
the Calender too.
Suhail A. Sallam
Head of Quality Division.
Integrated Solutions Dept.
Applied Computer Services Co. (HASIB)
> Running exchange 2007. In outlook 2007 I am receiving th...