• VBA to separate overlapping times

    I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here...

    Jace75 pointsBadges:
  • Search for column header in Excel 2007

    I use a macro for a weekly report. In the macro i use "Column ("C:C").Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: "90_day_Late". How do i search for...

    Francino5 pointsBadges:
  • Why are my Word and Excel documents automatically zipping in Microsoft 2007?

    Why are my Word and Excel documents automatically zipping in Microsoft 2007? When I save a document, is there a specific way to name them that will prevent this?

    Celticgirl5 pointsBadges:
  • Problem creating during hyperlink recall with Excel 2007

    if am copying a folder in desk top that folder contains xl2007 sheets, in one of the sheet i was inserted some hyperlink for supporting folder.if am pasting this folder in desk top it may creating some problem means after opened the xls file am clicking the link that time file could not be found...

    Msn8525 pointsBadges:
  • Excel 2007 and Picture mode

    When working in Excel 2007 Compatability Mode (XP, 2003 Office) when i go to cut, copy past the data into another spread sheet it pops into Picture Mode and locks up the data. If I put the data into 2007 and then cut, copy, paste it is editable and I can work with the data. Is there any way to turn...

    Fischerman7229260 pointsBadges:
  • Sending Excel 2007 spreadsheet without calculations

    I want to save a copy of my spreadsheet to send to someone, without them seeing my calculations. I need to convert the equation, save the answers as they appear in number format. I know there is an easy step but can't find the terms to search it properly. (Excel) Can someone please assist me?

    Matilda5 pointsBadges:
  • rows don’t line up or text does not appear with excel 2007

    I have instances where the rows (left freeze panel) do not line up ( and right panel)!!! sometimes the text does not appear on the screen, OR looks like it writes over itself. Happens when i do a control f to find text usually but not all the time. Anyone else having this problem?

    Peasandcarrots5285 pointsBadges:
  • Unable to Refresh Pivot Table if Datasheet in Excel 2007 is not open.

    I have several Pivot Tables linked to several like spreadsheets, respectively.  When I refresh a Pivot, I get an error that excel is unable to open the file (that the table is linked to). If the file is open, I can refresh.  My problem is each spread sheets contain huge amounts of data. Is there...

    Skb195510 pointsBadges:
  • Excel 2007 freeze pane problem

    Dear Sir, Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003. Regards Furqan Ahmed

    Mobilink115 pointsBadges:
  • Tracking active Excel 2007 table updates

    CAN I SEE THE ACTUAL CHANGES SOMEONE MAKES, ON A SECOND OPENING OF THE SAME WORKBOOK (SHEET) ON A DIFFERENT COMPUTER OR (DIFF MONITOR OF THE SAME USER). I WANT TO OPEN THE SAME WORKBOOK ON TWO DIFFERENT MONITORS (OR COMPUTERS) AND TRACK (SEE) THE CHANGES LIVE (OR NEAR LIVE) ON THE SECOND. THE...

    Tmore5 pointsBadges:
  • Excell VB

    Woring on an excel 07 spread sheet. I would like a code that disables printing and saveing until all required cells are completed/filled out and clears the cells after printing. Any ideas

    Freeride5 pointsBadges:
  • Conditional Formatting – Excel 2007

    Greetings. I was on hiatus from this excellent forum for some time. Got involved in too many other tasks & was unable to free myself to devote time to this forum. Now, I am seeking help on how to extend Conditional Formatting rule. The scenario is this: I have a worksheet with about 200 rows. In...

    SbElectric2,540 pointsBadges:
  • Graphing Challenge in Excel 2007

    I am working on a project, and was wondering if there is a quicker/better/easier way to do it than what I have been doing. I have two sets of data - one for 2009 and one for 2010 - broken out by department (there are about 100 different departments with which I am working). The data sets contain...

    Mchel275 pointsBadges:
  • Excel 2007 macros

    In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?

    Mcvla5 pointsBadges:
  • View row labels as column headings when scrolling in Excel 2007

    Row 1 contains the column labels, when scrolling the A, B C column headings are replaced with the row names. It is not "freeze" situation.

    Onthemove5 pointsBadges:
  • How do I disable save/save as and control +s and f12 in excel 2007?

    I want o disable those and only allow save feature through the macro I established

    Errtu5 pointsBadges:
  • Excel R1C1 referencing

    I have an excel spread sheet created via Crystal Reports export as a data only 2000-2003 excel (xls). Within this spread sheet are cells containing formulas with R1C1 referencing. When I open the spread sheet, the formulas are not calculated. I have changed cell referencing to R1C1 via the Office...

    BTod45 pointsBadges:
  • Matching data in Excel

    Hi, We have two sets of data in Excel that we need to match up and combine when they match. Spreadsheet 1 has two columns, A is a S/N and B is the page count. Spreadsheet 2 also has two columns, A is the S/N and column B is an ID number. We need to match the S/N from spreadsheet 1 with spreadsheet...

    Aslan5 pointsBadges:
  • How can I e-mail data to be viewed in Excel?

    How can I e-mail data, to be viewed in Excel, from a programme written in VB6, so that when the recipient opens it, the Excel workbook shows not only the data, but copies all the formulae, eg. Totalling columns etc. and the formatting, eg. colours?

    Martinyk10 pointsBadges:
  • Does excel 2007 on Win 7 64 bit create temp files?

    We have a user who was working on a file for a long period of time when the power went out. She had not saved it recently but shouldn’t we be able to grab a temp file? Excel 2007 on a Windows 7 laptop. 64 bit.

    Karl Gechlik9,860 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