• Microsoft Excel is displaying ### for long text

    I've hit a crossroads. I have a long Microsoft Excel spreadsheet with long text in just one cell. Instead of line breaks, I keep getting these symbols "####." What can I do to get rid of these symbols?

    ITKE342,685 pointsBadges:
  • Is there a way to auto-refresh an Excel auto-filter when the data is changed?

    Is there a way to change the value of a cell so that when it is filtered, the current row disappears?

    ITKE342,685 pointsBadges:
  • Excel Macro to extract substrings from a comma-separated string.

    How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

    Sdsdsd15 pointsBadges:
  • Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?

    Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...

    Kaylee5 pointsBadges:
  • Oracle Forms to MS Excel

    I have several reports which extract data via Oracle Forms into MS Excel. But Excel cuts off the input at row 999.  The Oracle Form uses the DDE.EXECUTE(ConvID) command.  Does anybody know if Excel has a limitation of the number of rows it will import via Oracle Forms?

    Mayac35 pointsBadges:
  • Export multiple files to Excel using CL

    Hello, I have these queries on a job schedule now and I want to export them to Excel using CL. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two files to? And can I run both queries this way?

    Querys100 pointsBadges:
  • Problem with shortcut error messages

    I was moving folders around in my documents when something I did erased or moved some of my folders. The documents were Excel spreadsheets with formulas. I ran a search and a couple of them came up but when I click on them, I get the error message: Problem with shortcut the item " " that this...

    Mh1125775 pointsBadges:
  • Can I find an Excel merged cell size in VBScript?

    I have a set of Excel spreadsheets which all have similar properties and I'm trying to automate a set of processes on them. I'm a compelte VB beginner, but it's going ok - I've just hit a stumbling block with the internet isn't being very helpful with. Once I have found a certain cell, is it...

    Bengreen15 pointsBadges:
  • Put rows in numerical order

    I have data entered randomly and now I want to sort it numerically using a certain column as the numbers to sort.

    Kooka5 pointsBadges:
  • Excel 2007 – gauge, speedometer, or dial charts

    Hi, Does anyone have any idea were I could find some some sample templates on these 3 for: Excel 2007 - gauge, speedometer, or dial charts. Thanks Jared~

    Jreifenstein001185 pointsBadges:
  • Combo box in Microsoft Excel

    How do I link numeric values to word choices in my combo box? I have tried If Then's for if you pick a certain choice it = a certain number, but I'm stuck! Thanks.

    Toriel5 pointsBadges:
  • SAP export to Excel 2007

    When exporting a spreadsheet to Excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I've tried to format the cell but this does nothing. Also I've verified switching the regional settings but no luck there neither. Help will be truly appreciated, Max.

    Duscher5 pointsBadges:
  • Convert spreadsheet into a flat file

    I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?

    Kioh4650 pointsBadges:
  • SSRS Excel export

    Hello I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.

    BBoy5 pointsBadges:
  • Associate or link cells in Excel

    I have a 30 person sales staff and I'm keeping track of the sale of one item on a monthly basis (31 rows, 13 columns). There are ten 3-person sales teams and I'm trying to get a team total for the 10 teams based on what each salesperson sells during a given month. I can total each individual's...

    Rbecker6915 pointsBadges:
  • Unable to run macro in Microsoft Excel 2007

    I'm unable to run any macros stored in this workbook but macros stored in the personal file will run. What should I do?

    Rich6245 pointsBadges:
  • Exporting data from report 6i to excel

    Can anyone tell me how to export data from report 61 to excel? I am looking for the code to do this.

    Pandoogroup15 pointsBadges:
  • Excel Macro Help – .ThemeColor = xlThemeColorDark1

    The spreadsheet I'm working on pulls data from an oracle database and automatically populates cells for which there is no data with "999999." I am attempting to use an excel macro to essentially gray-out all cells that contain this value with the intention of saving users the time it takes to apply...

    Jwahl5 pointsBadges:
  • TMP Files in MS Office

    When I'm saving in DOC or Excel file, a temp file gets created automatically. That happens only when I'm saving the file to 2003 format though I'm using MS 2007.

    Wahaib30 pointsBadges:
  • Disable saving in Excel 2007

    Hi, I need to get rid of the save option. I only want the sheet able save when the document is closed and it asks if you want to save. I do not want the document to be saved any other time. Here is my document (Office 2007 Only). http://www.savefile.com/files/1848919 It has been made to book out...

    Juel35 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