Posts by rajeevg

  • HTML_Interactivity

    Re: HTML_Interactivity


    Hi Buddy,


    first of all thanks a lot for the reply.


    However I tried thsi and it does not work as the graphs and reports i want to publish have external links and it gives error,


    can you please suggest another way out?


    regards


    Rajeevg



    Quote from reclusivemonkey

    Rajeevg,


    You can publish Excel Charts/Pivot Tables with all the interactivity they have in Excel (just about), *without* any third party add-ons.


    Go to "Save as Webpage", then choose "Entire Workbook" or "Selection:Sheet", tick the "Add Interactivity" box, then click on "Publish". You can then set where you want the page to be published when you save it. There are quite a few options for you to play with, you should be OK, if not search the Help or post again.

  • HTML_Interactivity

    Hi Guys,
    Please help me out,


    Basically i need help on excel and HTML interactivity.


    I have a pivot table and a normal chart in an excel sheet.


    I want to convert it into an HTML page whereby the HTML page will have the same pivot table and the chart.


    The trick is that i wanna upload this page to our intranet and i want the users to be able to work on the page same ways as they do in excel.


    Thus all functionalities will be available to users on HTM page.


    I am usinf Office 2003 standard edition,


    regards
    rajeevg

  • Pivot tables

    Hi,


    I have two datasheets ( Worksheets) and both have over 50,000 rows of data.
    The data is Date, Month, Employee id, and productivity. The Two Sheets are Deptt. A and Deptt. B.


    Is is possible to combine the two and make one pivot table which shows All employees and their Productivity month Wise.???


    Rajeev

  • Difference between dates

    I tried it


    Actually yes i tried it but didn't help,


    eg- if it is 15 hr and 10 mins-- it shows as 15:10 in hh:mm format,


    but if i make it to mm format- ideally it should show (15*60)+10 mins-- bul alas-- it shows only "10" in MM format,


    so had to go through all that


    thanks anyways :thanx:


    sincerely


    Rajeev

  • Difference between dates

    Dear Dave,


    it works,


    My formula returns 01 00:00 and not 24. This is true.


    It is a custom format for dd hh:mm now in the next column, i have converted into text by formula =text(result,"ddhhmm") and then put a formula to convert it into minutes,


    Try it,


    Regards,
    Rajeev

  • Difference between dates

    I could do it myself


    Hi Guys,


    sorry for disturbing you guys without trying much myself,


    I have got the solution myself and thought should share it with you,


    Please see the solution sheet,


    Rajeev

  • Remove spaces between numbers in a cell

    Use Replace function


    Here is a simpler way to do this,


    Just select the data, and say Ctrl+H ( For value replacement)


    In find what? give a space by clicking spacebar,


    In replace with- dont give anything and Click"Replace All",


    the spaces will be removed,


    hope it works,


    Rajeev

  • Dynamic Conditional coding

    This is great


    Hi Bill,


    Lovely!!!! this is great. This is really wonderful and I think i can now work on this.


    However it has one shortcoming and i am sure u can help me with that.


    In the Pivot you just sent, if i drag sex down and NAME UP, it doesn't work,


    I think you can give me a solution for this also.


    Thanks a ton,


    Rajeev

  • Dynamic Conditional coding

    Complex example


    Hi Bill,


    This one could be a tougher example,


    In the Pivot table now we have two marks column- Marks and Marks 2.


    ( We can also have marks 3 and mark4 all having different codes).


    NO if i try to play around with the table say- move Sex don, or name up or age up to the page, it disturbs the complete conditional format.


    I need something whereby whatever i do with the pivot, the should identify the fields and apply the conditional code.


    Or let me put it this way- In the sheet attached, i have set the format on th e cells. I want to give it to the whole filed say- marks and marks2 and not specific cells.


    One more case could be when i append data. When i append some data the pivot tables become longer and then the coding doesn't apply to those cells.
    For that i might have to give the code for the whole column.


    Please tell me if we can give the code for the Field(heading) and not the cells.


    Regards,


    Rajeev

  • Dynamic Conditional coding

    Hi Bill,


    I am extremely sorry that you felt bad, I had no motive to hurt you.


    To be very frank your example has given me an idea to solve the problem and i am thankful to you for that,


    Rajeev

  • Dynamic Conditional coding

    No it does not


    No This one does not help me. Actually this is a much simpler example.


    In my sheets, i have 5-7 such columns and all have different code.


    In that a situation that does not work and does not give me flexibility i need.


    For example in the shheet you have sent, If i take Age to the Page and then, drop doen the SEX i.e now the pivot table will show- SEX then NAME and then Marks, the whole conditional code goes off and gets applied to Name as well,


    I need a much more flexible option,


    Please help


    Rajeev

  • Dynamic Conditional coding

    Hi All,


    One thing which is trobling me for a long time.
    Is is possible to give DYNAMIC conditional coding in Excel.
    i.e I should be able to set a conditional format for a "Field" and not specific cell.


    Please tell me ASAP if Dynamic Coding is anyhow possible,


    Thanks in advance,


    Rajeevg :?

  • Converting American Date in String format to UK Date format

    HI,


    select the date ( Or the cloumn which contains the date), From the menu bar select>> "Text to Column"- Select first option> "Delimited", Click "Next" and once again" Next". Here you will get an option at - right top corner which states " column data format". here click date and select the date format you want to see. click finish,


    this will work, have a nice day


    Rajeev Gupta