Search results for query: *

In Excel I am trying to summarize the total value for a set of data based upon date ranges. The data consists of various "effective dates" that indicate when an item changed status (P1, P2, P3, etc). An item cannot repeat the date of status change, however the status can jump from any level to...

There is a fomula within XL to determine column width =CELL("Width",A2). I like to place this formula in row 1 for every column used within each sheet. This is handy when I wish to keep various worksheets looking the same from sheet to sheet or file to file. I have searched but have not found...

I've been using Excel and the "MS ODBC for Oracle" driver to query Oracle and Access tables. When I use parameters, I can point to specific cells in the spreadsheet to pass those values along to the query. (which is easier to change compared to bringing up MSQuery each time) When...

I use any number of PC's throughout the company that will have XL2000 or XL97. If I edit a spreadsheet using XL2000, from that point forward any time I am editing the same spreadsheet using XL97, I get the following "information" message: This file was created using a later version...

Each day a summary of parameters from within an Excel pricing model are saved to a text file and then archived into a database for long term storage. I need to modify the pricing model significantly, and the layout of the text file will also change. I was wondering if anyone knows how to check...

I have an Excel 97 file that refuses to open. In fact, during opening the file, it closes out of Excel completely. I tried disabling macros, opening in Excel 2K, but nothing seems to work. The file is ~235K and seemed to save normally last night. I have no idea of anything I may have done to...

Is there a way to set a number of formats in Excel as the default? For example : Align vertical FontSize 10 Number Accounting 2 decimals, no prefix etc... I realize these can all be set "after the fact", but was wondering if I could control what Excel uses as the default.

Can anyone help me with the following error message : Application exception occurred: App: excel.exe (pid=1112) When: 3/20/2001 @ 13:12:09.005 Exception number: c0000005 (access violation) I created the file using Excel 97, and it contains a series of charts that...