Excel Error Message
How do I clear error message #value#

Answer Question   |  July 11, 2012  1:29 AM
Excel 2000

Are Oracle direct queries straightforward?
Hi,  Our company uses an Oracle driven database application (java through internet explorer).  At some point I can get reports in PDF for several predefined reports, but there isn’t a way to retrieve the data from Oracle to an Excel spreadsheet, for easier post-processing.  Is there any feasable way of connecting directly to the server [...]

Answer Question   |  February 16, 2011  11:18 PM
Database Application, Excel 2000, Oracle, Oracle Query, Windows Server 2003

Excel R1C1 referencing
I have an excel spread sheet created via Crystal Reports export as a data only 2000-2003 excel (xls). Within this spread sheet are cells containing formulas with R1C1 referencing. When I open the spread sheet, the formulas are not calculated. I have changed cell referencing to R1C1 via the Office button, formula options, but the [...]

Answer Question   |  September 28, 2010  5:10 PM
Crystal Reports, Crystal Reports Export to Excel, excel, Excel 2000, Excel 2003, Excel 2007, Spreadsheet functions

Importing large sets of Excel 2000 data to SQL database
I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?

Answer Question   |  August 18, 2010  8:08 PM
Data migration, Excel 2000, Excel Database, Excel worksheets, SQL Database, SQL migration

Excel 2000 cannot open .ods file
I have a client using Excel 2000, and he is unable to open an Open Office Spreadsheet in his email attachments. I have set the file association, and tested the actual file to make sure there is no corruption. No matter what, this file will not open on his computer – a message comes up [...]

Answer Question   |  May 1, 2012  9:33 PM
Excel 2000, Open Office, Open source software, Windows XP Pro

Crystal Reports 11 problem with excel spreadsheet
I AM USING AN EXCEL SPREADSHEET AS MY DATABASE. ON THE SPREADSHEET I HAVE A COLUMN THAT HAS NUMERIC AND ALPHA VALUES. WHEN A ADD THIS TO THE CRYSTAL REPORT ONLY THE NUMERIC VALUES DISPLAY AND THE FIELD CANOT BE FORMATTED AS ANYTHING OTHER THEN A NUMBER FIELD. ON THE EXCEL SPREADSHEET THE COLUMN IS [...]

Answer Question   |  July 9, 2010  4:14 PM
Crystal Reports 11, Excel 2000, Excel Compatibility, Excel Database, Excel Formatting

AS400 Transfer to Excel with a Locked Cell
Hi everyone I hope someone can help me with this. I have an Excel template for a download for a group of users. The cell containing the formula was requested by management to be locked due to some of the users incorrectly removing the formula or leaving old data in cells outside the screen view [...]

Answer Question   |  February 4, 2010  7:19 PM
Excel 2000, Exporting AS/400 to Excel, Microsoft Excel

Brushing up on Microsoft 2000 for a test
I am taking a test on MS Excel nextweek. It has been a long time since i have used this type of program. This might be strange I rather use 2007. I woild like to brush up on my MS 2000. Where can I get this information?

Answer Question   |  January 12, 2009  8:26 AM
Excel 2000, Microsoft Excel 2000

I am unable to do my Import, when I run my macros I received two errors, running excel 2003
I Need some ones’ assistance with this error that I am getting in my excel spreadsheet: “compiler error in hidden module: ChroniclesExport ” This error is only when I’m running the MACRO’s function. The MACRO has been checked by other colleagues at my work and is running fine on some PCs & but it fails [...]

Answer Question   |  March 13, 2009  5:54 PM
Excel 2000, Excel error messages, Excel macros, Microsoft Excel

Deleting Excel Worksheets with macro
I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the [...]

Answer Question   |  December 31, 2008  12:38 AM
Excel 2000, Excel 2000 macros, Excel macros, Excel workbooks, Excel worksheets, Microsoft Excel, Microsoft Excel 2000, Microsoft Excel 2000 macros

2003 Excel crash
Excel 2003 crashs when opening a Excel 2000 spreadsheet with graphs. Recovery removes the graphs.

Answer Question   |  October 24, 2008  8:26 PM
Excel 2000, Excel 2003, Microsoft Excel

How to save a document as current date ?
I’m using VBA in excel 2000 to create a macro that saves out a spreadsheet with today’s current date. I cannot figure out the code that will achieve this function. Help Please

Answer Question   |  April 22, 2008  7:15 PM
Excel 2000, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications