Pages

Search

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