• Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • Excel 03 opens as Read Only always

    We have a user that is only able to open Excel 03 files in Read Only. No other MS Office does this to her. It even happens to Excel files she has created and files that she receives in emails. Any ideas would be helpful since we are at a loss. Windows XP Pro SP2, MS Office w/Outlook 03. Thanks

    Littlejuanito7420 pointsBadges:
  • excel macro formated to highlight current date

    I have a calendar in an excel workbook that I would like to develop a macro that could be formated to highligt the current date. I have my dates formated as the serial date. When I write my macro it highlights the same "number" "=DAY(TODAY())" in every month.

    Jlcford15 pointsBadges:
  • Microsoft Excel code for save name and check it exists

    Hi sir, I need one code sir that will create one Excel file to save name and mail ID and then check that it  already exists by using VB.NET and Excel.

    saranyaumasankar25 pointsBadges:
  • What are Excel internal limit for size and formula complexities/

    MS Excel 2003 and 2007 crash when handling oversized spreadsheets. The RAM memory is 4 gig and has plenty of memory. The machine is running Windows XP Pro. The spreadsheets have many calculations and formulas and have been set to Manual. Also have tried the 'control-end' on each sheet to no avail....

    Gaiusd5 pointsBadges:
  • Problems oprning Excel File

    I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below: [Excel found unreadable content in 'filename.xls'. Do you want to...

    EB35 pointsBadges:
  • Excel 2003 docs now won’t open in Excel 2007

    I created som docs using Excel 2003. New computer has Excel 2007 installed and now when I open the docs they are unreadable. Any help would be appreciated.

    Anniedun5 pointsBadges:
  • How to repair corrupt MS Excel 2003 (XLS) File?

    I have important MS Excel file data and unfortunately got corrupt due to virus attacks, so my crucial Excel sheet got lost, how to repair corrupt MS Excel 2003 (XLS) File? If have any solution please assist me.

    henrychandler5 pointsBadges:
  • vlookup in Excel 2007 to 2003

    Is it possible to vlookup in 2007 excel file to 2003 excel file

    Suresh123455 pointsBadges:
  • Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003

    When I import a DB2 z/OS query result  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example...

    Erredi5 pointsBadges:
  • Automatic date

    How can you set up a cell to activate the current time when another cell has data entered into it? Just want to track what time DATA was entered in the other cell.

    Bispo120 pointsBadges:
  • EXCEL 2003 and VLOOKUP help in calculating percentage in third cell

    Hi all, I have three cells in an Excel 2003 worksheet. Cell one is a drop down list containing: 01/07/2009 – 30/06/2010 01/01/2009 – 31/12/2009 Cell 2 is a dollar amount which is manually entered Cell 3 will calculate a dollar percentage of Cell 2 dependent on which date range is chosen in Cell...

    Ianmax4975 pointsBadges:
  • Created Public Folders for Excel spreadsheets

    I have created a public folder to store Excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes. Will all changes be saved?

    Chenzo5 pointsBadges:
  • Transfer of data from AS/400 DDS Described file to Excel spreadsheet

    I have a critical problem in AS/400 data fetch query in MS Excel (Petch SP2 loaded). I have created several Excel Sheets (in MS Office 2003) for fetching the data from AS400 using MS Office Query option under Data-->> Refresh Menu. Those excel sheets are using by so many different users on...

    Skm200520 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:
  • Cell Automated Population using Excel macro

    Hi, Is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you so much in...

    Eron09135 pointsBadges:
  • One formula for a single column in Excel 2003

    I am using MS Excel 2003. I have a spreadsheet with the exactly the same formula in every cell of a given column (This is possible by using the row() and the indirect() functions). The spreadsheet is using 6000 rows. Currently, I have copied the formula into each cell. This increases the...

    Gosteelers5 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:
  • 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:
  • Using Access query data in Excel

    I have a need to use some employee data that is contained in an Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. I can move the entire file, but I really need to move only the data that meets some selection...

    Ronmcnaughton5 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