• Microsoft Excel Graphing

    I has been awhile since I have used this site. Most of my posted in the past have been with SQL. Now I am in a new industry. So Now I am working on a presentation in the financial world. I have compiled a graph of all the high or top income paying percentages starting for 1913 till 2013 (100 yrs) I...

    CompEng1,240 pointsBadges:
  • Don’t delete Excel files in server

    I put the files of Excel in server that I have been spent a couple of days on it. I would like to keep it for other users to use it but I don't want other can delete it. So, what can we do to put the file in server and not allow other to delete? Please help me.

    Rathana15 pointsBadges:
  • Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 pointsBadges:
  • PDF save as TXT file (VBA)

    Hi experts, I want to save a text file from PDF file through VBA (XLS) coding. I want to get the data as text mode from a specific PDF file in Excel Spreadsheet. Thanks, Ananda Debnath

    AnandaDebnath280 pointsBadges:
  • Updating a shared list

    I have 30 people in my group. I need a way that they can each document a problem with a particualr system we all use. I've been doing this with an excel file - everybody just opens the file and enters a new row of data when they find a new issue. Now, we need to do this so often several people may...

    SomeDudeinTX20 pointsBadges:
  • Office 2003 excel filter

    Within excel 2003 I have 1245 records in a sheet and I try to add an auto filter and not all items in that column are in the list, why. When I select just a few cells in the column and apply the auto filter the missing items are there but highlighting the whole sheet or just the entire column and...

    Mhill10 pointsBadges:
  • One macro to systematically run F5 key on up to 20 other macros

    I have put together a series of macros which autofilter information to create a report on different tabs within a workbook. Having 17 macros all similar it would be handy to have one macro which would systematically activate each Module in turn and therefore require just the one key combination...

    AsHappyAs75 pointsBadges:
  • Have Excel shortcut erroneously deleted now cannot transfer file back

    This action only for products that are currently installed. The file is okay, I just need to get shortcut back on desktop.

    donlewter5 pointsBadges:
  • Extra columns on export to EXCEL

    How do I avoid the extra columns upon Crystal export to EXCEL?

    Bozotheclown10 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:
  • SQL Export to Excel file column?

    I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

    Shamilh10 pointsBadges:
  • Exporting data from SSIS to Excel

    I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I go about this?

    WindowsServerATE335 pointsBadges:
  • MAXIF formula in Excel

    Excel has SUMIF and COUNTIF functions, but I don't find a comparable MAXIF function. Can such a function be added into Excel? Any suggestions for sources?

    TomGlass20 pointsBadges:
  • Microsoft Excel Graphing

    I need a line that is able to move. I want to grab it with my cursor and move it up and down on my bar graph. The bar graph is showing the zero to the max percentage of the percentage of income brackets for each year from 1913 to 2013. So there are 100 vertical columns (bars). The series of the...

    ITKE351,865 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE351,865 pointsBadges:
  • How to save the exported Excel files from Oracle Forms 6

    Hi, I am using oracle forms 6.0. I generate multiple excel files from oracle forms and am using ole2 to export the data into excel. But i dont know how to save those files into the local machine. please someone help me. Thanks in advance

    Rajanoracle10 pointsBadges:
  • How to export an AS/400 physical file to Microsoft Excel?

    how to export as400 physical file to excel

    Reskind5 pointsBadges:
  • Data Transfer from AS400 to excel

    i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP if...

    Saranyahere5 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 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