Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count number of "Yes" between two dates Sophie Excel Discussion (Misc queries) 4 March 27th 09 05:48 PM
Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered pmdoherty Excel Worksheet Functions 4 February 6th 09 11:23 AM
Formula to count number of time stamps within a range in a column having dates formatted as "custom" Sam Excel Discussion (Misc queries) 3 June 19th 07 12:33 AM
macro for converting number stored as "text" (or preceeded with ') to "number" formatting markx Excel Programming 1 June 30th 06 12:14 PM
macro for converting number stored as "text" (or preceeded with ') to "number" formatting markx Excel Programming 1 June 23rd 06 03:15 PM


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"