2007

  1. D

    New code for Excel 2007 causes error in Excel 2000

    Hi I have a workbook that I have designed in Excel 2000 which I am now trying to get working in 2007. I am slowly working through the things that are not working and changing the code accordingly. One issue I had was that I needed to include the following line of code to make the workbook...
  2. R

    How to deploy EXcel 2003 Pivot Table format in Excel 2007? Please Help!

    I am very much comfortable with Excel 2003 Pivot table. But i am using Excel 2007. The problem with excel 2007 pivot table is for each Row Position is not showing in Seperate column (only tab space is coming). If i try to copy & paste the Pivot table in a new sheet, then each row is not copied...
  3. J

    How do I get the description field to display in Access 07?

    In Access 03 the navigation box had a description field that was always displayed and sortable by. In the Access 07 navigation pane it has gone away. I use the description field in all my databases quite extensively for notes and reference and to label the order in which certain queries are to...
  4. M

    Losing Excel 2007 Ribbon with MSVDM

    Hello This is a bit of an annoyance for me and is probably not very common. I use Microsoft Virtual Desktop Manager which gives me 4 different desktops to switch between. When I am using Excel 2007 and I switch desktops, when I return all the menus/ribbon has gone so all I am left with is the...
  5. K

    Passing Excel Sheet Name to PowerPoint

    Hi All, I'm having a little problem passing an excel 2007 sheet name to Powerpoint 2007 as the slide title. Not sure if its a powerpoint issue or an excel issue but hopefully someone here will be able to help. I'm using the code below to copy all charts from excel to powerpoint (each slide...
  6. I

    How to add an additional series to a stock (i.e. high low) chart? (2007 SP1)

    I've created a high low aka stock chart, add another series and try to change the chart type of the additional series to be a line chart, and Excel forbids it. I know I did this once with Excel 2007 pre-SP1, because I saved it as a template. Problem is, post-SP1 that template doesn't work...
  7. C

    VBA Worksheet_Change Help (might be a simple thing)

    I'm not a VBA or Excel expert, but I thought the code below was pretty simple. It basically sorts a range of cells everytime a value on the sheet changes. It worked perfectly in Excel 2003, but in Excel 2007 nothing happens. Does anyone have any idea if there is an incompatibility, or maybe...
  8. Y

    Error from Excel 2003 to 2007

    Hello, My company had been using 2003 when I created a very large macro looped through files checking each one to a certain criteria. Now that we have upgraded to 2007, it does not recognize at least the first part of the macro that sets up the loop. Could anyone tell me why it is not...
  9. T

    Charting blank cells as 0 when using dynamic ranges

    In an Excel 2000 workbook, I'm using dynamic ranges to define a cell range. I need to use dynamic ranges because the data in the spreadsheet changes each day and re-creating all of the charts manually would be too much work. A simple example of the problem is below Sheet1 A B...
  10. I

    Excel 2007 Stripping Out Formatting

    Hi We are having a rather bad experience with our Excel 2007 spreadsheets. It seems that when saved out as 2003, all the formatting is removed from the document. No more borders, background colors, text colors, nothing but text. I've been trying to figure out why and can't come to any...
  11. D

    Macros not working in 2007

    Hi I have a pretty large workbook with many thousands of lines of code in hundreds of sub routines. Included are routines to create custom toolbars, control MS Word, change the look of Excel (API calls???) and many aspects of locking the spreadsheet down including protecting sheets and using a...
  12. B

    Convert Excel 2007 workbook to web app

    Hello- I have a client who is developing an ROI calculator in Excel 2007. They would like to consider converting the workbook to a web app eventually. Questions... 1. Is there a way to do this within Excel 2007 natively? 2. Are there any "best-of-breed" tools that can be purchased for this...
  13. B

    Are protected Excel 2007 workbooks really secure?

    Hello- I have a client that is developing an ROI calculator using Excel 2007. They are saving the ROI calculator as standard .xlsx and protecting all areas of the workbook that do not require user interaction. Their plan is to distribute the .xlsx file to customers directly and via their web...
  14. A

    excel 07'; shadow affect in selected cells

    When i highlight multiple cells I can not see any distinction between the cell selected vs. the cells not selected. How can this be adjusted to a darker shadow/shade?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top