Pages

Search

Excel Help Forum - Excel General: Summing and Averageing, based on criteria.

Feed2Mail notification - new post on Excel Help Forum - Excel General
Summing and Averageing, based on criteria.
Hi All, I currently have an excel table with staff members names (which wont change) and I'm seeking a way to work out the average time it takes them to complete a project. Attachment 188957 (http://www.excelforum.com/attachment.php?attachmentid=188957) In this example John and Mike both...

Excel Help Forum - Excel Programming / VBA / Macros: Web Query Help? - Query Picture Title or Alt Text on a webpage?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Web Query Help? - Query Picture Title or Alt Text on a webpage?
Hey, I am querying a few things from a webpage with getElementsByClassName right now and it is working well. However I want to be able to get the picture title or alt text from html? It may just be changing the options with getElementsByClassName, but I am not sure how. Here is an example...

Excel Help Forum - Excel General: Sort on cells with all caps

Feed2Mail notification - new post on Excel Help Forum - Excel General
Sort on cells with all caps
There is a solution here, which prioritizes capitals http://www.excelforum.com/excel-general/699248-case-sensitive-sorting-all-caps-first-then-all-lowercase.html But what I want is to have first cells where all letters are capitals, and then cells with lowercase or mixed case in a way that it...

Microsoft Word - Publish to Blog with Endnotes

Microsoft Word - Publish to Blog with Endnotes


Publish to Blog with Endnotes

Posted: 22 Oct 2012 10:06 AM PDT

I cannot publish to blog with endnotes.  The endnotes are not included in the blog post and the superscript numbers in the blog post are missing.  Is there a way to fix this?  I could use endnotes if there is a way to get that working but that does not seem to work either.

 

I have Office 2007 Professional but I am willing to upgrade to later if necessary to fix the problem.

Mail Merge Word 2007 files using parameter based Access query

Posted: 21 Oct 2012 10:25 PM PDT

Hi,


We recently upgraded our users from 2003 to 2007 Office (Standard), meaning they do not have Microsoft Access

installed on their machines as it is not part of the license.

 

We have some vital documentation with headers containing mail merge info.

This mail merge information is stored in an Access query with a parameter (so the users can run the documentation for a specific result from the database)

 

After the upgrade, the Word 2007 file looks for Microsoft Access and if it isn't installed, it causes an error.

 

Is there a way around having to install Microsoft Access for every users who needs to run a mail merge for these documents?

 

Thanks


 

 

How to add definition dictionary to Research pane in Word 2002?

Posted: 21 Oct 2012 02:27 PM PDT

How can I create the dictionary "Look-up" command in the right-click research task pane for Microsoft Office XP Professional 2002? When I right click over text, I don't have the Look-up command, only the thesaurus. When I edit my text in Word, I want to define certain words. I've used this utility before, but I've seemed to have lost it when I had to reinstall my OS.

[Original title: chrisdodt]

how can I stop Office from saving FAPxxx.tmp files to my desktop

Posted: 19 Oct 2012 04:28 PM PDT

each time I open Word, create a document, nd not even necessarily save it, but perhaps print it--I then find a whole bunch of FAPxxx.tmp icons saved to my desktop--maybe 10 or more. How can I prevent this from happening?  This is a relatively new happening, even though I have been using Word for  3 years years with this computer.. 

Find alphabetic directory for clip art

Posted: 19 Oct 2012 10:12 AM PDT

Last week in doing a 2007 Word document I found an alphabetic directory with red print for special clip art and pulled up a numbered site for recyclable symbols from #1 to #7. Now I can't find the alphabetic directory.. 

Protecting template styles in Word 2003

Posted: 19 Oct 2012 07:21 AM PDT

I am using Word 2003 on XP. I have set up a template but when I copy and paste a document into the template, it brings in the document styles. I can delete the ones that have different names but it changes the existing ones, like Heading 1, etc. How do I protect template styles in Word 2003?

Thanks!

Word 2010 Hyperlinks Don't Work In Emailed Document

Posted: 18 Oct 2012 02:04 PM PDT

Hyperlinks work fine until I send the document via email.  Do I need to add share permissions to allow others to open the hyperlinks?

List numbering problems in Word 2010!

Posted: 17 Oct 2012 01:40 PM PDT

Why doesn't the List Number in a table enable me to restart the list at 1? The function works when the list is not within a table, but the function is not even AVAILABLE within the table list (see diagram that follows). This is extremely annoying, especially when I need to pass the document to a person who does not know all the poorly thought out and senseless problems of formatting and styles in Microsoft Word. To me, this is incompetent programming and a time waster.


 

cell alignment option

Posted: 17 Oct 2012 12:54 PM PDT

How come sometimes in MS Word when I right click in a label cell I get the cell alignment option and sometimes I don't?

Excel Help Forum - Excel Programming / VBA / Macros: Printing current time and date.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Printing current time and date.
Hello, I would like to create a button that on double click prints the current date and time in their respected cells then clears itself on another double click. Currently I have coded a button to show a completed and not yet completed state (see attached) but am not sure how to incorporate...

Excel Help Forum - Excel General: Is there a way to apply conditional format if duplicate BUT only for a certai...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Is there a way to apply conditional format if duplicate BUT only for a certain value?
I have a userform that's outputting data to a worksheet (schedules) and it's okay to have a duplicate schedule for someone unless it's a late shift (10:00pm, value is outputting as 10:00) in which case, I'd like conditional formatting to highlight the cells. I've messed with it but I can only do...

Excel Help Forum - Excel Charting & Pivots: X and Y avlue on scatter plot

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
X and Y avlue on scatter plot
hi, let me know how to calculate the extrapolite the value on linear graph? i m able to calculate the x and y at 0, but i wanted to know if the value at 20.9.Attachment 188931 (http://www.excelforum.com/attachment.php?attachmentid=188931)

Excel Help Forum - Excel Programming / VBA / Macros: Creating a list of single values from a list with multiples of that value

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Creating a list of single values from a list with multiples of that value
Hello, I am not entirely sure that my problem falls under VBA/macros, but I am writing a macro, so here is the problem: I have a workbook which has lists of data for several buildings. The data spans several weeks and is labelled by the day and time that it was recorded. So there are about 100...

Excel Help Forum - Excel General: Wearout Determination

Feed2Mail notification - new post on Excel Help Forum - Excel General
Wearout Determination
I have this solved through some helper columns, but I was curious if anyone can deduce a single formula solution... Basically, I have a piece of equipment that can make 4000 units before it breaks. I have a yearly forecast of units needed. I would like to determine at what time the equipment...

Office IT Pro General Discussions Forum: mailmerge issues with coping excel spreadsheet

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
mailmerge issues with coping excel spreadsheet
i am trying to make a mailmerge with my excel spreadsheet and word document. when i merge the two together, the word document has 12:00:00 AM where it should be blank information. how do i correct that. i have 2007 office

Excel Help Forum - Excel Programming / VBA / Macros: How to import data from webpage (from ajax)

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
How to import data from webpage (from ajax)
Dear Members, I would like to download data from the following webpage with ajax on that page. http://www.dukascopy.com/tradercontest/?action=liveForecast When I want to download data from page 2, the website does not generate a new web address and one of the great members have already...

Excel Help Forum - Excel Programming / VBA / Macros: Still learning arrays, not sure how to work with a particular range input/edit

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Still learning arrays, not sure how to work with a particular range input/edit
Attached is the demo for a scheduler program I'm nearly finished developing. The final part I'm having to deal with is entering in a particular range of information (the start times and lunch times) from the userform (AddNew) into the active sheet and then using the EditPrior to pull the data back...

Excel Help Forum - Excel General: Complex Batching Problem

Feed2Mail notification - new post on Excel Help Forum - Excel General
Complex Batching Problem
I have a file a 60k excel spreadsheets and I need to figure out a way (if possible) to pull them into a single excel worksheet. I know if push comes to shove I can code this in C# but my company isn't wanting to give me access to visual studio thanks -Jacob

Excel Help Forum - Excel Charting & Pivots: Calculating Weighted Averages in Pivot Tables

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Calculating Weighted Averages in Pivot Tables
Does anyone know the best way to have a pivot table return a weighted average instead of the standard average? Within the attached spreadsheet I have a pivot tab. I'd like to create a weighted average for the APR. Currently it shows 4.62%. On the data tab I calulated the weighted average at...

Excel Help Forum - Excel Programming / VBA / Macros: Filter one column with multiple checkboxes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Filter one column with multiple checkboxes
Hi excel guru's!! I am in need of some VBA coding that will allow me to filter a specific column with multiple check boxes. For example, I have a worksheet with over 100 rows of data and each row in column B has a month. Can I have check boxes for each month and filter my data based on the...

Excel Help Forum - Excel General: Excel 2010 Slicers

Feed2Mail notification - new post on Excel Help Forum - Excel General
Excel 2010 Slicers
I have 3 different pivot tables on the same sheet. It's an employee commission sheet. The employee sold policies for 3 different products. On the sheet, it has his/her break down laid out in 3 pivot tables. Each different pivot table is for a separate product, and all 3 pivots are based off 3...

Excel IT Pro Discussions Forum: Excel using Processor but not RAM

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel using Processor but not RAM

When we run Excel 2010 x64 (large calculation) it consumes all of the processor 100% but less than 1% of the ram. How can I force (or firmly request) excel to utilize all of the RAM (24GB) that the machine has available. 

If I add another processor - what settings can I manipulate to let excel utilize multi-core processing?

Windows 7 PRO 64bit, 

Thanks,

SJ

Excel Help Forum - Excel Programming / VBA / Macros: Add the similar ID

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Add the similar ID
Hello Everybody I want to add the similar IDs, for the sake of example workbook is attached with this thread.

Excel Help Forum - Excel General: Changing Axis

Feed2Mail notification - new post on Excel Help Forum - Excel General
Changing Axis
If I have information going along the x axis, how can I switch it all to go the other way along the y axis?

Excel IT Pro Discussions Forum: Excel External Data Connection and SharePoint 2010

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel External Data Connection and SharePoint 2010
I've recently installed SharePoint 2010 and TFS 2010.  I've setup the Secure Service Store but find an issue when working with the external data connection in Excel 2007.  The only authentication methods are Windows, SSO and None.  I don't see an option to use SSS.  Will it still work the same and go after credentials in the SSS database or will it look specifically for an SSO database.

Office IT Pro General Discussions Forum: Outlook 2010 - Quick Steps Limit

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Outlook 2010 - Quick Steps Limit

Hi

Does anybody know if there is a limit to the number of Quick Steps you can create in Outlook 2010?

Thanks, Viv


Viv Haig

Excel Help Forum - Excel Programming / VBA / Macros: Conditionally formatting the color of the lines connecting two points on a sc...

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Conditionally formatting the color of the lines connecting two points on a scatter graph
Good Morning, I am working on a project by creating scatter graphs that show how each facility is improving based on 2 key metrics, Lines Handled Per Hour (LPH) & Errors/1,000 Lines Shipped (Quality). An improvement in LPH means that the number should be greater and an improving in Quality...

Excel Help Forum - Excel General: Why, oh Why does it show me the formula instead of result

Feed2Mail notification - new post on Excel Help Forum - Excel General
Why, oh Why does it show me the formula instead of result
I am entering a simple formula =MIN(range) and it shows me the result. I make any edit (e.g., add $ so that I can copy the formula acros without rows changing), hit return, and it shows me the formula instead of the result. Now anytime I type a formula in that cell, it shows me the formula not...

Office IT Pro General Discussions Forum: MS Access 2010 - DB in 2003 format - Autonumber 2007-2010 - getting a Duplica...

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
MS Access 2010 - DB in 2003 format - Autonumber 2007-2010 - getting a Duplicate Key message, Access 2010
We have had multiple times, approx. 2 twice a month for the last 4 months, when we are getting a duplicate key message and no users can enter new rows.

Looking at the table there is not a duplicate record.

The only table connected has a field as a primary key, autonumber field type, and index (no dups).

If I delete all the rows and reload the table, the users can add rows again.

We are running MS-2010 Access, with a AccessDB formatted as 2003. Is this a MS bug?

Russ

Russ Neuman

Excel Help Forum - Excel Charting & Pivots: Help plotting filled shapes (currently plotting outlines using scatter)

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Help plotting filled shapes (currently plotting outlines using scatter)
Hi all, I have been able to plot a shape (in this case an ellipse or series of ellipses) using the scatter plot, however, what I would really like to do is fill this shape in with a solid colour (as opposed to just the outline). Is there anyway to do this? I would have thought it shouldn't be...

Excel Help Forum - Excel Programming / VBA / Macros: Pulling values based on selection from drop down box

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Pulling values based on selection from drop down box
I am not sure I posted this in the correct area, my apologies if not. I am trying to find the best way to pull data into a series of cells based on the selection made from a drop down box. For example, in the drop down box I have a list of companies we work with. Company A, Company B, and so...

Excel Help Forum - Excel General: How to delete rows if column A1 and B1 are equal to A2 and B2

Feed2Mail notification - new post on Excel Help Forum - Excel General
How to delete rows if column A1 and B1 are equal to A2 and B2
Hey guys, How do you automatically delete all rows EXCEPT ONE when for example A1,B1,C1,D1 are equal to A2,B2,C2,D2 AND copy the remaining one to another sheet if column E is greater then 4 999 999.99$? For example: A B C D E 1| 13232 | 250 | 1800...

Excel IT Pro Discussions Forum: Excel cannot access 'Start Menu' error when open Excel 2010

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel cannot access 'Start Menu' error when open Excel 2010

Excel cannot access 'Start Menu'  .  The document may be read-only or encrypted error window when open Excel 2010. Followed by this error window, 'Start menu' cannot be accessed. The file may be corrupted, located on a server that is not responding or read-only.

All other Office 2010 applications open fine without this error.  XLStart is located locally on this Win7 desktop. After selecting "OK" to each of the windows, one can open Excel fine.

Excel Help Forum - Excel Charting & Pivots: [SOLVED] Scaling positive and negative values on primary and secondary axis r...

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
[SOLVED] Scaling positive and negative values on primary and secondary axis respectively
Hello Guys, I have the following data: Katalog Redemption Platform Miles -302351940 -764328242 Bookings 7082 11861 Now when I am trying to plot a graph with Miles on Primary Y axis and Bookings on...