Pages

Search

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...
Subscribe to: Posts (Atom)