Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speed and the "number dates".
Just getting around to Office 2007. Yes, Excel is slower (so is
Access - bit). I think the graph problem is related to dates on the X-axis. All of my spreedsheets are populated with data from access databases. I simply use Excel to make graphs. In Excel 2003, there is an X-axis date column phenomenon where a date will sometimes be represented as a "number" and sometimes as a "date" (this shows up in 2003 in how the x-axis "format" shows the ranges). The "number dates" work differently than "date dates". It appears to me that Excel 2007 is having problems with these "number dates". I've got spreadsheets of roughly 20 - 30k rows. Some are graphed as quickly as in 2003. But (so far) the ones that are slow have the "number dates" on the X-axis. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of "Yes" between two dates | Excel Discussion (Misc queries) | |||
Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered | Excel Worksheet Functions | |||
Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Excel Discussion (Misc queries) | |||
macro for converting number stored as "text" (or preceeded with ') to "number" formatting | Excel Programming | |||
macro for converting number stored as "text" (or preceeded with ') to "number" formatting | Excel Programming |