How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta.
While in an Excel Pivot table created in Access, I somehow became "stuck" in
a bar chart view. I'd like to view my data in "Pivot Table Form" not as a
chart. Is there a toggle button or some other way to get back to a Pivot
If it's an embedded Excel file, there should be sheet tabs along the
bottom of the window.
You probably had a cell selected in the PivotTable, then clicked the
Chart Wizard button, and it inserted a new sheet for the PivotChart.
Click on the other sheet tabs, and you should find the pivot table.
Jersey Girl wrote:
&g...Pulling data daily from a differently named report everyday
I have a spreadsheet where I use formulas to pull data from multiple
reports on a shared server everyday. What I do is to save those
reports under a certain name everyday since the formulas have to have
the static report name in them to pull data. (For example, A1 may pull
data from c:\reportfolder\reportA, B1 may pull from c:
\reportfolder2\reportB, etc). In these report folders our IT group
runs a new report in it everyday but of course they change the name of
the report every day (to reflect the date) . . so in the reportfolder
there will be "reportA-3-12-2009", and "...no one able to login to crm
when login,system report error,invalid authorization. the user authentication
passed to the platform is not vaild.
there is article talk about this,id 860612,but still unable login
This could be an Active Directory problem. CRM checks if the user is in the
AD UserGroup, but if AD replication is not working then the user's group
membership may not have been applied. Check the membership of this group on
each DC by explicitly connecting to each DC in Active Directory Users and
David Jennaway - Microsoft Dynamics CRM MVP
"yang"...Different margins on different pages
I am setting up a template for letters at work. The first page of our
letterhead has one ste of margins and all subsequent pages will have a
different sent of margins.
I know that section breaks can be used, but if staff copy and paste text
from existing letters into this new template, the section break moves.
Is there any way of locking the section break to the page? so the pasted
text goes over the top of it?
You could setup your document with a 'different first page' layout. That allows the first page to have a different set of margins to
the rest o...Two RPC over HTTPs clients one connects the other can't
I have two RPC over HTTPs clients - both going through the same router. One
connects the other cannot. The one that cannot was only using windows
firewall and I've turned it off and it still cannot connect.
If I use a vpn client to our server it connects fine.
I can't figure out why one works without the vpn client and the other
Check the client AV Firewall on the computer. Trend Micro, Symantec now
include the firewall with AV client. If everything checks OK, try opening
outlook at a run command with outlook /rpcdiag. What hap...Different values for error bars in series
In Excel 2007, how do you put in different error bar values for each data
point in a series? So far I am only able to put in one value for all in my
See Jon's blog on the subject.
On 06/04/2010 15:52, wdwind1 wrote:
> In Excel 2007, how do you put in different error bar values for each data
> point in a series? So far I am only able to put in one value for all in my
> bar chart.
Andy Pope, Microsoft MVP - Excel
...Copying multiple fields from one form to another
I have two forms, FormA and FormB, based on table A and B.
Both tables underlying the forms have different autonumbers as the
Essentially, what I need to do is build a macro that :
Copies the contents Field1 and Field2 from the current record in Form
Creates a new record in Form B, then
Pastes the contents of Field1 and Field2 from FormA into FormB
Any help gratefully appreciated
You've described a "how". Now, "why"?
If you are intending to copy data from FormA (based on TableA) to FormB
(based on TableB), you are trying to copy data from TableA t...A Different CRM for GP
We are pondering the idea of implementing MS Dynamics CRM. However, I am
curious whether anyone else has had success in integrating a different CRM
product with GP 10.0. It's not that we don't like the MS product; I just
like to ensure I have covered all bases.
Our partner does not have any other recommendations as they have not worked
with any other CRM applications.
Any information would be greatly apprecaited.
GoldMine is a good product, very mature, and easier to maintain table
structures. There are links to GP but I cannot remember the fir...Save only One Worksheet To Separate File
I need to place into a Word document, only one of several worksheets in a
workbook. When I shade and save that worksheet, I get the entire workbook.
Can someone please point me in the direction for these instructions.
Right-click on sheet tab and select 'Move or copy'. Check 'Create a copy'
and in 'To book' field, select 'New Book'. OK
You get a single-sheet new workbook. Save it under a new name.
(Don't use my reply address - it's spam-trap)
"John Gregory" <email@example.com> wrote in message
news:ekPA9W...2 users access calendar online with different rights
user A wants to give user B permission to see, add and edit entries in
user B is able to see, but not to add or edit entries at the moment
in outlook itself its working. user B can open the folder calendar of user A
and make entries and change entries
what have to be done that this is possible also with web access exchange ?
On Thu, 26 Oct 2006 14:09:29 +0200, "Mike Schwarz" <firstname.lastname@example.org>
>user A wants to give user B permission to see, add and edit entries in
&...Same column, different cell width at different row
I have tried inserting a break and split, didn't work. I just want to
separate the top half of a page with the bottom half so I can apply different
cell width on the same column. Or how would I be able to do this? Same
column but different cell width.
You can't do that.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Glenn Chung" <GlennChung@discussions.microsoft.com> wrote in
>I have tried inserting a break and split, di...Fixed Assets
When using the Fixed Asset module, I am finding some small differences when
compared to the Depreciation calculated by the External Accountants for tax
purposes. Client would like to match exactly to the amounts calculated by
external accounts. What is the best way to fix this issue?
Need more info Patti. What are the depreciation methods/settings that
are creating the differences? Does this occur on every asset or just
MCP-GP, MCT, MVP
East Coast Dynamics
get your gptip42today at www.gp2themax.blogs...Removing days header and attachment view in Entourage mail
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: imap
I'm a new Mac user and using Entourage mail. I have two questions: <br><br>Remove days headers: When viewing my inbox, each days mail is headed by a row that gives the actual day (Today, Yesterday, Saturday, Friday, etc.) Is there any way to remove these? <br><br>Remove attachment view as default: When i view an email in my inbox, the attachments view automatically is open. This takes up some viewing space for my actual mail. I can click the little arrow to condense, but is ther...Two Text Lines in one Cell.
Is there is a way to have two text lines in one cell. Please advise. Thanks
When you type text in to a cell, use ALT+Enter to insert a line
break. To combine two cells in to a single cell, you can use a
formula like =A1&CHAR(10)&A2 . Ensure that the cell has Wrap Text
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Peter" <email@example.com> wrote in message
> Is there is a way to have two text lines...Dates Difference
I need to get the difference between 2 dates (in number of days), how
do i get that in vc++? I have used the DateDiff function in asp but
couldn't find anything like that.
Also, how can i convert string to a date?
thanks in advance
>I need to get the difference between 2 dates (in number of days), how
>do i get that in vc++?
Convert (if the dates aren't already in this format) the dates/times
to FILETIME and subtract the values.
>Also, how can i convert string to a date?
Try COleDateTime::ParseDateTime or VarDateFromStr.
MVP VC++ FAQ: http://ww...macro to convert multiple worksheets into one
Is there a macro that I can take a work book that has 8 seperate worksheets
of data, and put all the data on one worksheet?. I need to sort all the data
on one sheet. Currently I cut and paste the data to the one sheet.
Any help would be appreciated.
Ron de Bruin has lots of sample code at:
> Is there a macro that I can take a work book that has 8 seperate worksheets
> of data, and put all the data on one worksheet?. I need to sort all the data
> on one sheet. Currently I cut and paste the data to...Want to display value and difference on one chart
I am trying to create a chart that displays x and 10-x on the same chart. I
want the chart to show a meaured value and the difference of that value to 10
in a different color.
On Wed, 6 Aug 2008, in microsoft.public.excel.charting,
JMH <JMH@discussions.microsoft.com> said:
>I am trying to create a chart that displays x and 10-x on the same chart. I
>want the chart to show a meaured value and the difference of that value to 10
>in a different color.
Use your spreadsheet to calculate the values, then use the chart to
graph them. Never try to use a chart for calculation.
...How do I move my appointments from and old pst file to a new one?
My Outlook pst file has been growing and the solution to decreased the size
is to create a new pst file.
All emails are now moved.
All contacts have been moved too.
The problem is moving the appointments from one pst file to another.
Thank you all in advance.
However you did it for emails and contacts, for appointments it works the
same way. You could use the File/Archive, or move some items manually. In
order to do the latter, switch to a table view.
Michael Bauer - MVP Outlook
Category Manager - Easily share your categories:
SAM - Automati...Sending from 2 different computers
I have Outlook 2003 on my desktop at home and 2002 on my laptop while
traveling. My server is Comcast. I would strongly prefer to use
Outlook (rather than Comcast's webmail) on both computers.
I have configured Outlook on both computers to receive email. I can
also leave a copy on the server so it can be downloaded again later on
the other computer, assuring that I always have copies of all emails
no matter which computer I'm using.
Problem is I can't send from my laptop. I've tried Comcast's
instructions for configuring Outlook 2002 for use while traveling, but
it doesn&...Different shape width in different views in Excel 2007??
In Excel 2007, I create a shape in "Normal" view and set its width to
any value (e.g. to 15cm). Now I change to "Page Layout" view and guess
what... the width now shows up as something more than 16cm??!
(The width property as points in VBA changes accordingly.)
Switching to "Page Break View" will result in one more different width
Is this "just" a big bug in Excel 2007 or did I miss something??
I know that the selected default printer or the chosen zoom factor may
have an influence on the shown size of a shape, but these discrepancies
are ...Make a sheet for one year?
Is there some kind of coding that can be put onto a sheet or workbook that
will ignore data from a prior year?
Here's the specific dilemma. I downloaded a General Ledger from the
Microsoft website through exel, new, microsoft office online, ledger,
I work on a fiscal budget so, naturally, I have 2009 data and 2010 data on
the same sheet. The sheet has the following formula in it for a 2009 entry:
The formula for a t...appointment prints different time
My client uses a french CRM with date format dd/mm/yyyy. when he creates an
appointment with the SFO client from e.g. 11 o'clock until 16 o'clock it is
saved like correctly. but when he prints it out, the starttime is 8 o'clock
and end time 13 o'clock.
it is like that for every appointment. it always prints out 3 hours earlier.
Anybody had this too?
You can check if both the server and the user are in the same time zone.
Open Control Panel, Date and Time, Timezone
On the laptop open Control Panel, Date and Time, Timezone
Open CRM vi...Sharing one exchange for multiple (small) company.
I need to share a new Exchange 2003 Standard (not Enterprise) for 3
organisation. Same information store, same mailbox limits, ...
Each one will have its own syntax for smtp adresses (firstname.lastname@example.org ,
email@example.com, firstname.lastname@example.org). I will organise all in OU, at least one
per organisation. How can I affect smtp adresse according to its
location is AD (OU) ?
Other question : how can I have an adresse book per organisation ? One
have not to see people of the two others.
Thanks in advance.
...Different Columns on different pages
Hi - think this will be easily resolved but I am stuck!
In publisher 2000 how do you create a multipaged, two page
spread that has different columns on some pages.
I keep bringing myself back to "ignore background" and
trying to use "arrange" - "layout Guides" - but this isnt
Am I thinking too deep? Is the whole point that the
layout guides are simply guides and stay the same thorugh
the whole document regardless.... you just use ruler
guides to make the changes through the different pages?
What is the difference between CRM standard and professional?
> What is the difference between CRM standard and professional?
Does it have anything to do with Outlook integration?
I am Johnny!
Your Internet penpal.
I have a scooter, how about you?
"Johnny" <email@example.com> wrote in message
> Johnny wrote:
> > What is the difference between CRM standard and professional?
> > -Johnny
> Does it have anything to do with Outlook inte...