Excel - Fill Series

Hi
Using Excel 2003

For a file, the fill series command is invalid, why is that so?

thanks

  Gord Dibben replied to PL

Invalid or "unavailable"?

Is the sheet protected?


Gord Dibben  MS Excel MVP

Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB

Excel and the Math Coprocessor for DLLs Excel I have a large Win32 DLL (10 MB) that is called from my user interface (written in C++) or from VBA in MS Excel. In my user interface, the DLL runs in its own space and calculates correctly. Under Excel VBA, my DLL is having problems with double precision accuracy. The following test passes in bottom CHPTST = (DIVTWO * bottom) - top In my user interface, the chptst result is zero. Under Excel VBA, the chptst result is 0.2851266E-09. I have tried resetting the math coprocessor _status87 (); if (old87Status ! = 0) new87result = _control87 (new87ControlWord, new87ControlMask); I have verified this behavior in both Excel 2003 and 2010. Does anyone have any ideas here ? Sincerely, Lynn McGuire Excel Discussions Windows XP (1) Visual Studio 2005 (1) Microsoft Excel (1) Visual Studio (1) Excel

Selecting a point on a chart in Excel 2007 on Windows 7 Excel Hi, This may seem like a repost, but I believe that the first post was a macro that operates on a point, selected on a chart. It works fine in Excel 2003 on Windows XP, Windows 7, and in Excel 2007 on Windows XP. However, I cannot seem to select a point by clicking on by clicking on another point or by using the keyboard (both ways work fine in Excel 2003). Is there a way to *reliably* select a point on a chart in Excel 2007? Thank you! - - Kirill. Excel Programming Discussions Windows XP (1) Office 2007 (1) Excel 2007

Excel 2007 Stock market Charts Excel I teach a class in financial modeling. Some of my students use Excel 2003 and some 2007 (They are required to consult the company from whom they have accepted an offer and use the version of excel the company uses). In 2003 we generate a candlestick (Open High Low Close) Stock Chart for a company. We then add Volume. What is a good exercise in 2003 is a disaster in 2007. The candlestick has a fixed gap (unless you go into hidden secondary category axis that you cannot access in any way - we have tried. The excel 2007 preset Volume Open High Low Close Chart has two major problems. One, nobody in

Apparent Excel 2007 chart HasTitle race condition Excel The macro below works correctly, i.e. creates a chart without a title, with Excel 2003, but the chart has a title with Excel 2007 SP2 and the Excel 2010 beta. (The macro requires numeric data in the range A1:B10 on the first worksheet.) The macro *does* work correctly with Excel 2007 if I step through it in the debugger (thus introducing delays between each statement statement (in particular *two* DoEvents calls seems to work). My company's application that uses Excel for reports has larger macros containing similar code that must run correctly on many PCs