• export to ms excel

    I get extra columns when exporting to MS excel. It appears there is an extra column every time there is a sub report

    Mstang19875 pointsBadges:
  • Excel 2007 Macros problem

    Hello, I am using Office 2007. The Macros are disabled when we open password Protected Workbook. What should we do?

    Mobilink115 pointsBadges:
  • Excel 2003 toolbar functions greyed out, but not Excel 2007

    I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). Could Office...

    Trevor1c5 pointsBadges:
  • Issues with Microsoft Office 2007

    OS: Vista Home Premium Here's a list of the issues I'm experiencing - very strange behavior. 1. When I try to open a .doc or .docx file from Windows explorer, word opens up, but doesn't display the document - just the grey default screen. When I open up word, and then open a file up from there, it...

    Mouse19995 pointsBadges:
  • Excel Calendars

    I have a schedule and would like to put the current months calendar as well as next months with cells that I can add info to for each day. Currently someone has to update the dates from month to month. Is there a way to have the calender update by just changing the Month and 1st date?

    Sandman00730 pointsBadges:
  • Excel 2007 – formula or macro to show value from one cell next to a given reference

    Hope someone can help. I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG - Sheet 1 has a cell with £500 in cell 3A The reference 1.01 is located in cell...

    PeteAtGlasshead5 pointsBadges:
  • Excel 2007 what is the command for scrolling down your rows with still seeing the header row at the top

    I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. Thanks so much!

    Buddyboy12310 pointsBadges:
  • Convert Number value in text string

    I am using Microsoft Excel 2007. I want automatic conversion of a number value into relative text string. It means if I have "687" into one cell, then it should be converted into "Six hundred and eighty seven" into next cell. Please guide me for this.

    Makkes5 pointsBadges:
  • Deleting successive rows on Excel 2007

    Using VBA in a large timeline excel worksheet of 50000 rows. How can I automatically delete every 3 rows and leave the 4th row so I can reduce the number of rows to about 12,000.

    Debress5 pointsBadges:
  • Excel Macro

    I created a macro and it is saved in personal.xls. How can I make this macro available to other users? I want to be able to give them the ability to run the macro - they do not need to modify it.

    lorit365 pointsBadges:
  • Finding Seasonality for a large number of items in Excel.

    I am trying to establish any seasonality with what is, unfortunately, a large number of items and a relatively small time sample.  I have 32,000 different items which have typically sold at a steady pace over the past three years.  I have the sales of each item by month for the previous three...

    XENOPHON222,340 pointsBadges:
  • Cell color coding

    I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I cant see the formula used...

    Mas85 pointsBadges:
  • UK date formatting in MS Excel 2007

    As I enter a date in UK format in Excel 2007 it is taken as text. The date I entered is 23/12/2009. How to get it as a date.

    kotayyam5 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:
  • 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:
  • vlookup in Excel 2007 to 2003

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

    Suresh123455 pointsBadges:
  • Password remover for Excel 2007

    I have forgotten my password for my imp Excel sheet. How would I recover that Excel sheet now?

    Gvk5 pointsBadges:
  • Macro to breakout data into separate tabs

    I have a weekly report that holds line item detail for seven different account numbers. The data is going to vary from week to week and I need vba code that will separate the data by account number into different tabs. Any tips on how to write the code? RWC

    HNAvigator20095 pointsBadges:
  • SUM and IF formula

    Using Sum on a column of currency of 2 decimal positions. Using IF to compare that Sum total to another total. To my knowledge, all cells are defined a 2 decimal postions. Some value entries result in the Sum total having a "1" in the 10 decimal position and some value entries do not result in the...

    LASloan5 pointsBadges:
  • VB6 App with hardcoded SQL to access a Access 2007 DB

    Hi Team, I have a query that I run successfully in native SQL within Access 2007 but if I use this code within VB6 it seems as though it is not using the "From" & "To" dates. It does return values but it amounts to the complete database totals. The extra code added to the production code was...

    Witsend10 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