• Linked Workbooks return #VALUE error until linked workbooks are opened

    I used to save linked workbooks onto a remote server. One could be opened and it would display the last values it had. Now, the linked formulas show #VALUE error until the linked sources are opened. I'd really like to be able to open just one workbook at a time. Is there some setting in Excel 2007...

    Blubudda15 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:
  • db2 to excel

    i was tryin to import from db2/400 into excel but when i did. the description came up in a different language...in db2/400 the description was in araic then when i imported in excel it came up a different language?? any idea plz help  thank you

    Doodoo5 pointsBadges:
  • SQL Server 2005 Legacy DTS fails when run as a job

    When the DTS is run from SQL Server Management Studio within the Legacy Data Transformation Services the log shows Executed By: sqlagent

    Ftornoe40 pointsBadges:
  • Inputing greek symbol in concatenated text

    I am trying to concatenate the contents of several cells (which contain alpha numeric data) into a text statement and and also concatenate the Greek letter "mu" representing micro to the end of the statement. When I do this it appears as m. It seems as if I need to be able to specify a symbol font...

    HENRYj5 pointsBadges:
  • Create Excel file on web server by using SQL

    How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I'm retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a stored procedure...

    SwapnilD25 pointsBadges:
  • How to recieve a excel file via AS2 running on iSeries

    I need to schedule to download reorts from Walmat retail link. The reports are generated in excel format and downloaded using AS2 protocol. When I receive the file in iSeries it is not readable. I need to convert the excel format into data base file format. Any thoughts

    AS25 pointsBadges:
  • How can I use a variable in my macro to import data from as-400 to excel?

    I import data from our as-400 to an excel spreadsheet to do further analysis.  One of my criteria is the customer number and that is what I would like to be a variable. Hence under the vba that retrieve the info, that criteria now read like this   "WHERE (ORDDET01.CUSN='3559')" When i tried to...

    Yves69520 pointsBadges:
  • CPYTOPCD as an XLS

    I am using CPYTOPCD and emailing the resulting *.csv and *.txt files successfully. However, I am now trying to send the data as an XLS. Although the file is sent, the data does not appear in the different cells as I would expect, the whole string (although comma delimited) appears a whole string...

    Ricca100 pointsBadges:
  • Access denied message when trying to save on network

    Hi all I have Server 2003 operating system om server.and officeXp with Office2007 on desktop when I work some EXCEL work on Desktop and treid to save on server it give me "Acces denied" Is Anybody Have any sloustion for thant.pls help me to reslove the issue.thanks in advance.

    922657968770 pointsBadges:
  • Outlook 2003: Export PST Emails To Excel

    When I use the "File > Import & Export" command from Outlook 2003, I have mixed results. I keep my emails in sub-folders off one of several PST files that I use regularly, in the "All Mail Folders" side-panel. I broke up the larger folders into smaller ones in case there was a size limitation. I...

    CaliforniaJerry5 pointsBadges:
  • Add in option to transfer from Iseries to excel2007

    I cannot find where to add in the Iseries transfer from or to the Iseries in Excel 2007 running windows vista.

    Jpnick5 pointsBadges:
  • Is it possible to export gantt chart view to excel 2007 in MOSS 2007?

    Hello All,               Is it possible to export gantt chart view to excel 2007 in MOSS 2007?              Now i am trying to export gantt chart view but i am getting only columns in excel sheet. my requirement is i want gantt chart view with list columns in excel sheet....

    NASE5 pointsBadges:
  • Download Spool file to Excel Format

    Hi Guys, Do you have any idea how to download the Spool Files(WRKSPLF with PRTF) to Microsoft Excel?   Thanks Mickey

    SoulReaper20 pointsBadges:
  • BOM Download To Excel For I&PD Exercise

    Are there easy directions for me to download from the SAP BOM's comprising 7000 lines to Excel for manipulation and pivoting of the data?

    NDIRISH5 pointsBadges:
  • How do I limit the number of selected check boxes in a list to only having one check box selected in an Excel spreadsheet?

    I am recreating a transfer form we currently have on paper into an Excel spreadsheet to have it electronically emailed. In the form I have a section that asks the user to choose a desired station to transfer to from a list of 3 stations with check boxes next to each station. I would like to have...

    2knowmore5 pointsBadges:
  • Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i

    Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i

    JohnsonMumbai1,160 pointsBadges:
  • Converting SQL 7 Database to Excel

    Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks

    Bertski40 pointsBadges:
  • how to export the address book in lotus notes into a excel file or txt file

    my Nokia cellphone only support to synchronize address book with Windows Outlook. but our company mail system is Lotus Notes , how can I do then can synchronize address book from Lotus Notes into my cellphone? Thank you very much!

    Justin31585 pointsBadges:
  • Data transfer from AS400 to Excel 2007 Stops at 16,xxx rows

    I am using client server to access my AS400.  i downloaded and installed it within the last 6 months i have the excel add on installed and it seems to be working well on tables with less than 16,xxx rows.  1. can anyone help me find out if there is a more up to date add on for excel 2007? 2. My...

    Ringside35 pointsBadges:

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