1
  • 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 saying that...

    AndreaF8,065 pointsBadges:
  • Excel Error Message

    How do I clear error message #value#

    SandyCB5 pointsBadges:
  • 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...

    Acseven30 pointsBadges:
  • 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...

    BTod45 pointsBadges:
  • 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?

    ITKE351,965 pointsBadges:
  • 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...

    SATELE015 pointsBadges:
  • 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...

    Patcoad30 pointsBadges:
  • 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...

    IVANZAMU40 pointsBadges:
  • 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?

    Reverend1235 pointsBadges:
  • 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 macro without having this...

    Rbloxsom5 pointsBadges:
  • 2003 Excel crash

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

    Prthibodaux5 pointsBadges:
  • 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

    Data Mgt5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following