Pages

Search

Excel Help Forum - Excel General: Merging/Averaging a List of Rankings

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
Merging/Averaging a List of Rankings
Hey guys, glad I found this resource. I'm currently working on an assignment where I have 2 lists, each ranking websites based on traffic. The first list is very basic has two columns: ranking and domain name. The second is the same, but with slightly different rankings and a few domain names that...

Excel IT Pro Discussions Forum: The differences between vba of office 2007 and vba of 2010

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
The differences between vba of office 2007 and vba of 2010

Here's the deal.

My company decided to update the Office from 2007 to 2010. We use Excel mostly to processing economic data, and develop some vba program to do that. The problem is we have already developed a lot of vba program, and we are not so sure wether this updating thing will destroy some of them.

So now I need a list of the differences between 2007 version and 2010 version. This list should include every detail of both programing changes and application changes.

I have been looking for this kind of documentations on official website for more than a week, and I only get some general descriptions at present.

Is there anybody has the documentations like this, or knows the url of web pages contain this kind of information? Please share them.

Thanks

Excel Help Forum - Excel General: Need to distribute data from one worksheet to multiple spreadsheets.

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
Need to distribute data from one worksheet to multiple spreadsheets.
Looking for help on a sport's team payment sheet where the first tab is a running list of all charges and payments and each subsequent tab are the individual player's account balance. I am using only the first tab to input data and the subsequent tabs to contain formulas. How do I have the tabs...

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.