• Excel cell contents change when performing Word mail merge.

    I routinely use Word Mail Merge Wizard to produce mailing labels, extracting the address data from an Excel spreadsheet. When performing this operation today, the zip codes of the last five additions to the spreadsheet, while appearing completely normal in the spreadsheet, change to 0 (zero) in the...

    Nclimey5 pointsBadges:
  • Lonking worksheets in Excel.

    I am trying to link an Excel sheet from one workbook to another and it is working, but it does not look the same. I want the linked sheet to look exactly like the original sheet, but it doesnt work. I think it may be because the original sheet was manually inputted and i created a range and named...

    DDP5 pointsBadges:
  • Excel graph gaps

    I would like to create an "x,y" type plot ("scatter graph" in Excel terms) in which the "x" array is continuous, but some of the "y" values are invalid because the formula has a limited valid range. I can use an IF to substitute "" or "nil" "invalid" or something for the invalid "y" values....

    TomGlass20 pointsBadges:
  • Help finding duplicate info in Excel in different columns

    Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a duplicate. The info is the same just in a different column whether it be Store1 or Store2,...

    Hmstacco20 pointsBadges:
  • coordinate file import

    can I import cartesian coords into acad from wordpad or exel

    Moseseh5 pointsBadges:
  • MAXIF formula

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

    TomGlass20 pointsBadges:
  • Excel Macro to Create additional Sheets, based upon cell values

    I have a spreadsheet that contains a report of which department has an item entered. what I want to accomplish is to move the individual 'department' data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets....

    Donatelo305 pointsBadges:
  • Having problem opening Excel files on Zip drive results

    A reader asks: Hi There. My question relates to opening a file in Excel 2007. Briefly, files were created on another computer using Excel 2007, put on zip drive which I have been able to open print, update, etc. previously. Now it allows me to open the files, however, no data appears on screen once...

    BrentSheets6,925 pointsBadges:
  • Cannot Open Older Excel Files with 2003

    When trying to open older Excel files, i get this message: You are attempting to open a form that is blocked by your registry policy setting. How do I can my registery settings to access older Excel files???

    Reap5 pointsBadges:
  • Place Holder

    I have part numbers that are in the form of 12345678-001. I am trying to write a macro that will search through the 13000 lines of part numbers and enter a revision level next to it. I want it to only look at the first 8 numbers (before the "-"). This is what I currently have: Dim Timer As Integer...

    Davidhinze5 pointsBadges:
  • networking

    i have pc and thin clients in our bank how can i access to excel and word files on pc through thin client ?

    Sanjumaur5 pointsBadges:
  • automatic publish of charts to web

    On worksheet (5) I have graphs based on the 4 previous sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the republishing to be automatic. The graphs are updated once the data is changed but I want the user to use the intranet rather than the spreadsheet.

    Gerrib150 pointsBadges:
  • Updating textboxes on a Userform

    How can I get real time information in a text Box on a userform when a macro is running

    Alanr5 pointsBadges:
  • Excel Graph Question

    I have a graph that isn't graphing all of the data and I don't know what to check. I have the cell range going through cell "FA7" but it stops at cell "GH7". I have several graphs with this range that are working fine, but this one graph stops short and I can't figure out why.

    Swh0085 pointsBadges:
  • Deleting all formulas in a worksheet when unprotected in VBA code

    I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...

    Barnoldswick5 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:
  • importing an EXCEL tab

    while importing an EXCEL tab with the import wizard, ACCESS 2003 changes a text field with only numbers that exceeds the long integer format to scientific notation. Is there a possibility the numbers do appear?

    GIT02110 pointsBadges:
  • Macro determining end effective dates

    I am using Excel 2003. I am creating a data-entry spreadsheet that contains supplier costs for components. For each component (Record), it has a begin date for when the price goes into effect and an end date. Since I want a history of this item and the dates that it increased or changed, there will...

    Jhowells285 pointsBadges:
  • Designing a report in SQL from an Excel worksheet

    I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

    SQL Server Ask the Experts2,585 pointsBadges:
  • External references in excel gives error while mailing

    I had an excel file having external reference. When I email this file to someone else, it shows #REF! in the columns having external reference

    Kapilrewari5 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