Make a complete list of words from texts in a range
	Hey guys - again :) My challenge today is as follow: Sheet = "TEXT" In column A i have several celles with texts/comments - words/ sentences I want to split all the texts into singel words and make a word-list of all used words of this column A - and copy the words into a new sheet (sheet = "WORDS") column A as my complete word-list.... more » By Snoopy  - 13:14 - 2 new of 2 messages

	Problem with saving excel 2003 files on network
	I have a recurring problem with Excel 2003, when a user is trying to save an existing file on the network after a few minor changes in the file. Excel will shut down and no changes will be saved in the original file. But a different file is saved in the same folder without the .xls extension This new file contains all changes and the... more » By Johan  - 12:44 - 1 new of 1 message

	PRO11.MSI
	When I double-click an Excel attachment to an Outlook email, a window pops up and it cannot find PRO11.MSI, then error 1706, then Excel won't open. I have lost the installation CD-ROMs. By Mike Row Soft  - 10:41 - 2 new of 2 messages

	Pivot tables downgrade 2007->2003
	Welcome. I've created a few pivot tables in my report in Ex2007. The problem is that there is a group of ppl who have Ex2003 and these pivot tables looses their functionality (expanding) when opened in this version of Excel. Of course files are saved as *.xls format but it doesn't change anything.... more » By Przemek  - 08:56 - 1 new of 1 message

Excel2007: copying filtered table values, how can I copy ONLY the filtered values

Hi I am new to excel 2007. In previous versions of Excel if I : - added filters to a table, - filtered it (eg all names starting with ABC), - highlighted the filtered table, - copied it, - pasted values to another sheet.... it only pasted the filtered values. Which is exactly what I want. However when I do exactly the above steps in 2007, the paste seems to... more » By AC  - 00:48 - 2 new of 2 messages

	Problem with footer data with Excel 2003 and 2007
	Hi everyone, I generate an excel spreedsheet with html code. I create a footer like page of pagecount and I put this code : @page {mso-footer-data:"&D&P de &T";}. All work good with Excel 2007 but with Excel 2003, that doesn't work. Does someone have idea why 2003 do this problem and how to resolve... more » By simon_eyer  - 26 Nov - 1 new of 1 message

	Date Picker
	Hello, Is there a DatePicker in Excel 2007 so I can pick a date when I focus on a cell? If not, where can I get one? Thanks, Miguel By shapper  - 26 Nov - 2 new of 2 messages

	Pictures in Excel cells
	Dear friends I want to create a book with personal descriptions, including pictures. But how can I get a picture in an Excel cell? I thought that =HYPERLINK("file.jpg") would be the thing, but the pictures are not retrieved when I combine the Excel sheet to the final Word file. Please help. By José  - 26 Nov - 9 new of 9 messages

	Highlight Duplicate Column
	i want a vba code to highlight the duplicate value... the code needs to be dynamic i.e thru userform when i select a column it has look into tat particular column and highlight it ... By vicky  - 26 Nov - 1 new of 1 message

	PIvot Table top Values
	HI I have to generate pivot tables and only extarct the top 20 or 40 values. Excel 2003 has an option that could display the top values that I need - only. i.e. ' Pivot Table Options >>Advanced settings >> "Top 10 AutoShow" ' Where do I find that function in Excel 2007 ?? By !ngeniuos  - 26 Nov - 2 new of 2 messages