Pages

Search

Excel IT Pro Discussions Forum: PivotTable Date Handling in Excel 2013

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
PivotTable Date Handling in Excel 2013

Just testing out porting some 2010 reports into 2013 and found that Excel functionality has changed just enough to break them.  Curious if someone might point out a solution:

1) Report is pulling from a SQL database and/or OData feed.

2) I have projects along the Y axis.

3) I have standard stage gates along the X axis.

4) Each cell should depict the date upon which each project will hit the stage gate.

In 2010, I simply set up the PivotTable and then set the cells to display the "Max" value of the date.  After formatting the cell to appear as a date, it worked just fine.

In 2013, I get a message that I can't use the Max calculation with date fields in the pivot table.  Effectively, this breaks the report.  Is there an easy fix to this or do I need to break out some sort of combination of v and hlookups?

Thanks in advance....


Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

Excel Help Forum - Excel General: Listing unique terms from combined strings

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Listing unique terms from combined strings
Hi, I have string data in a column that I would like to create a list of just the unique terms. Each unique term string in the cell is separated by / . See below for a partial list. Each of these strings is entirely in one cell. I do not need the number of times or in what combinations the terms...

Excel Help Forum - Excel Charting & Pivots: A simple pivot chart doubt

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
A simple pivot chart doubt
Hi Everybody, I am using EXCEL 2010 in my system and I am working on some sales data. In view of the large data, I wanted to group my timelines with months instead of dates. So, I went into PIVOT TABLE TOOLS in the menu, selected OPTIONS to use the GROUP FIELD function, but the GROUP FIELD...

Microsoft Word - Word Printer problems

Microsoft Word - Word Printer problems


Word Printer problems

Posted: 28 Oct 2012 10:34 AM PDT

Just recently,  documents that are in word, neither new or old, will print.  The printer acts like it's printing, but it just shoots our blank pages.  Or maybe just the heading will print.  Have totally reinstalled my hp printer.  So don't think that's the problem.  It prints everything else fine.

I cannot open a word starter file.

Posted: 27 Oct 2012 03:48 PM PDT

I cannot open a word starter 2010 file. Error message "click-2-run configuration failure''. Have been using the program since purchasing pc. It came preloaded. I need to access my documents but cannot. What to do? My OS is Windows 7 - 64 bit. I do not want to upgrade as I do not need the full office program. Is this something that expires? I certainly hope not!

How do I change the number of minutes until the computer shuts down?

Posted: 27 Oct 2012 12:39 PM PDT

Could someone tell me how to change the number of minutes until the computer shuts down automatically?  It shuts down after only a few minutes of inactivity.  I want to lengthen that time by a few minutes.

hello,Please,currently I have tried to uninstall a program(trial version) of office 2010 home and student from my computer but it says I should contact microsoft for help. thanks

Posted: 26 Oct 2012 11:39 AM PDT

hello,Please,currently I have tried to uninstall a program(trial version) of office 2010 home and student from my computer but it says I should contact microsoft for help. thanks

Track changes in Ms word 2007

Posted: 22 Oct 2012 02:40 AM PDT

Hi

 Need to permanently remove 'track changes' from a document (word 07)

I did following steps
1. Click the Office button.
2. Point to Prepare and select Inspect Document.
3. Word will display the Inspect Document dialog box.
4. Check the first option: Comments, Revisions, Versions and Annotation.
5. Check any other options you want Word to inspect.
6. Click the Inspect button. (Word will prompt you to save the document if there are unsaved changes.)
7. Word will display the inspection results.
8. If any comments or revisions are discovered, you can permanently remove them by clicking the Remove All button in the Document Inspector dialog.

 goes to turn the feature off, saves the document and finds that 'track changes's is re-enabled!
# obtained a copy of the document.... explored... replicated issue. Looked in the menus and explored... (looked in doc properties), and entire track changes menu, etc. came up dry
# googled -- found: http://www.ptraining.com/blog/2010/10/permanently-remove-track-changes-from-a-word-2007-document/

i've googled this issue and attempted on my end to replicate the steps and follow the solution; and it is not working for her. when she opens the document, track changes is re-enabled!
# thank you much, in advance!

Word 10 - Proofing English Pack will not load. Spell check will not work

Posted: 21 Oct 2012 08:57 PM PDT

I have uninstalled and reinstalled the English language tool multiple times.  My Office is x32 and that proofing pack appears to load properly.  I go to File, Options, and Language and proofing shows as NOT INSTALLED.

 

I do not know what to do to fix this.  I cannot find a similar report on any website.

 

I'm running Windows 7 with all updates.  Office has the latest SP also updated

 

Thanks for your help

Problem merging the split documents in MS Word 2010

Posted: 21 Oct 2012 08:29 PM PDT

I got a draft letter of eight pages from a known source in ms pad. I opened it in ms word 2010. By mistake, contents of one page got split into two pages. I would appreciate if you could let me know as how to merge the same contents into one page?

Why do I have to pay for Word 2007 after installing Office 2010?

Posted: 21 Oct 2012 03:14 PM PDT

Original Title: Why am I now being told I have to pay for word 2007 after installing Microsoft 2010.  I don't understand???  I am also, now, very angry over the rigorous process to get this far!!

Get someone to answer my questions immediately!!  I am quite upset at the entire process..  I want to know why I am being charged for the exact same word program (2007), why I was not told about it, and where my old program went because I want to access the internet through word (and not on a trial basis).  That is what I thought I was paying for!!!!!


I also prefer speaking to a live individual, particularly when it comes to money!  Please provide me with a customer service phone number.

Microsoft Works - Problem installing Microsoft Works 2000

Microsoft Works - Problem installing Microsoft Works 2000


Problem installing Microsoft Works 2000

Posted: 04 Jun 2004 03:44 AM PDT

The only thing I can think of is maybe the CD's are
damaged and some things might not install. Maybe
scratches on them? Other than that I can't think of
anything.
 
version, can you answer 
is 

works 2.0a ?

Posted: 03 Jun 2004 02:06 PM PDT

Thanks..do u know if the ability to save as rtf is already part of works 2.0
or do i have to install something. I am helping a friend on their computer
so don't have the machine with me 24/7
thanks

"A.A. Fussy" <com.au> wrote in message
news:c9p05k$331$austar.net.au... 


Merging Works Database into Word Envelope

Posted: 01 Jun 2004 08:16 PM PDT

In my version of Word(Word 2000) you can save a document
in Works format. If you do that, you should have no
problems with the envelope function of the word processor
that comes with works.

James.

Converting MSWorks Database to Access

Posted: 01 Jun 2004 01:04 PM PDT

Thank you, I will

CLIP ART ON LABELS- WORKS 6.0

Posted: 01 Jun 2004 12:44 PM PDT

Thanks, Kevin. Let's hope MS can be inspired to make it
work - as it did very well in WORKS 4.5 
http://www.btinternet.com/~kevin.james1/index.htm 
message 
side 
sets 

Works Suite 2005 On DVD-ROM?

Posted: 01 Jun 2004 07:51 AM PDT

Hi Craig,

That has yet to be announced, by Microsoft

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2004
Website & FAQ: http://www.btinternet.com/~kevin.james1/index.htm





<microsoft.com> wrote in message
news:16b5301c4482a$39e6cd70$gbl... 


Works 7.0 will not install

Posted: 31 May 2004 06:50 PM PDT

There is a label with 3 barcodes and several long
numbers. I tried 3 different numbers as Product Id, and
none of them worked. Just now I noticed there is another
number I didn't try. Guess had better try that one. Web
site could have mentioned the label and told which number
it is. That woulda saved me a lot of time. That's
assuming this other number is the one.
 
Microsoft works 2004 & 
wrote in message 
All I 
drive. 
require a 

Can't find File

Posted: 31 May 2004 01:12 PM PDT

>I try the support site of your Family Tree Program. This 

Thank you for your suggestion. However, I don't think it has to do with FTM
but rather with the Search engine. When there is a file containing certain
words, no matter what the format of the file, Search should be able to find it,
don't you agree?
Pat

Install of Works 6.0 stops

Posted: 31 May 2004 09:42 AM PDT

Hi Dave,

Perhaps the following knowledge base articles, the first one references
error messages.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;242323

Works: Utilities to Help with Troubleshooting Works
http://support.microsoft.com/?kbid=297061

Hope this helps,
Ken

"Dave G." <microsoft.com> wrote in message
news:1603201c44739$201e2150$gbl...
I tried both installs and it still won't copy new files.


MS Works 7 database

Posted: 31 May 2004 08:52 AM PDT

Sue,

My previous instructions need modifying !

Go to Form Design View.
Create a new field ...
Go to Form View
Resize field etc....
Copy and paste picture ...

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2004
Website & FAQ: http://www.btinternet.com/~kevin.james1/index.htm





"Kevin James - MSMVP Works" <org> wrote in message
news:phx.gbl... 


Whenever I turn on the computer, I get a message that says:"SPRINGFLD_ADV_DAEMON: WksCal.exe - Entry Point Not Found

Posted: 31 May 2004 01:59 AM PDT


"Syed Farzan Faisal" <net> wrote in message news:... 
link 
pops 
the 
done 




birthdays, address book, calendar 7.0

Posted: 30 May 2004 08:02 PM PDT

Re: Any other ideas.

Reply: No

Ken

"Duyen" <com> wrote in message
news:16dbd01c44834$96bacba0$gbl...
Hi Ken,

I've uninstalled the update and am still having the same
problem. My address book saves all birthdays as Jan 01.
Any other ideas?

Thanks,
Duyen
 
Update Q330994 
calendar reverted to 
address book. As I 
book because after 


Opening Works 4.0 with...

Posted: 30 May 2004 07:06 PM PDT

On Sun, 30 May 2004 19:06:58 -0700, "Jennifer"
<microsoft.com> wrote:
 

Jennifer, you'd be best off following Kevin's advice about checking
your settings, and then stick with the latest updates of version 4.5 -
that's the best version of Works ever -- I've used it ever since it
came out, through Windows, Win98, WinME and now WinXP.


Mad? Subscribe to VITUPERATIONS - you'll get madder, and you'll like it!

Brochure Background color

Posted: 28 May 2004 03:03 PM PDT

You are correct. Thank you so much for solving my
probem. I selected "no watermark" and the background was
gone. Don't know what I (and others) would do without
you helpful folks out there that gives their time to
assist others.

Thanks again.
 
along 
being 
problem 
http://www.btinternet.com/~kevin.james1/index.htm 

Excel Help Forum - Excel General: Match names between two sheets

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Match names between two sheets
Hello experts, How do I link 2 spreadsheets together? I don't know if I used the term "link" correctly. As you can see, I created 2 sheets, there are name that the same and there are name in spreadsheet 2 that aren't in spreadsheet 1. I know the first step that I need to do is to seperate...

Excel Help Forum - Excel Charting & Pivots: Index of Pivot Tables

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Index of Pivot Tables
I have a spreadsheet with approximately 20 pivot tables using basically the same database. I placed all my data in one worksheet and all the pivot tables in a separate worksheet. However, it is difficult to manually find the exact position of each pivot table. How can I determine where all my...