+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14

Thread: MS Excel - find setting

  1. #1
    Rebelle
    Rebelle is offline
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    MS Excel - find setting

    Hi All,

    Ok, I'm exporting data from asp to excel....well, when I do it...I can highlight some column data and see the sum at the bottom of excel but other some columns it will not do this, I believe there is a setting that is not allowing it, does anyone know of such setting and where to find it?

    it's odd because I had some else do the same export and the columns that don't work on mine, work on his...and the ones that work on mine don't work on his. the currency values work on mine and on his they do not.

    Thanks!
    Rebelle, August 26th, 2009 03:46 PM
    Reply With Quote Reply With Quote
  2. #2
    Rebelle
    Rebelle is offline
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    I found one issue for the columns that weren't working on my machine...I had an space   after the rs("Field") on the asp code .
    Rebelle, August 26th, 2009 04:40 PM
    Reply With Quote Reply With Quote
  3. #3
    Lauramc
    Lauramc is offline
    I like Data Cubes too... Lauramc has a spectacular aura about Lauramc has a spectacular aura about Lauramc's Avatar
    Join Date
    Mar 2008
    Location
    Far Far Away
    Posts
    387
    Real Name
    Laura
    Rep Power
    5

    Typically this problem is caused by numbers being formatted as text or as you noted, non-breaking spaces added to the data. Did you surround your numbers with quotes? That may have something to do with it.
    Lauramc, August 26th, 2009 05:19 PM
    "The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS
    Reply With Quote Reply With Quote
  4. #4
    Rebelle
    Rebelle is offline
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Hey Laura,

    do you mean something like <%=rs("IntField")%>?
    Rebelle, August 26th, 2009 10:26 PM
    Reply With Quote Reply With Quote
  5. #5
    mehere
    mehere is offline
    Super Sarcasm Mistress mehere is a glorious beacon of light mehere is a glorious beacon of light mehere is a glorious beacon of light mehere is a glorious beacon of light mehere is a glorious beacon of light mehere's Avatar
    Join Date
    Mar 2008
    Location
    Wide Awake In Dreamland
    Posts
    830
    Rep Power
    8

    nope ... that's not surrounding the data with quotes. what's the code you're using to do this?
    mehere, August 26th, 2009 10:39 PM
    Quote of the Month:
    INSIGHT: When the going gets tough, the tough get going. The smart left a long time ago.

    Questions to Ponder:
    Are people more violently opposed to fur rather than leather because it's much easier to harass rich women than motorcycle gangs?

    iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
    copyright © 2008 sbenj69

    Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.
    Reply With Quote Reply With Quote
  6. #6
    Rebelle
    Rebelle is offline
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Hey Mehere

    ok, all the fields now work on my machine....so I'm guess its now a setting on his pc for excel.
    I removed the &nbsp; from the following:
    Code:
    <TD bgcolor="#F4A460" align=center><%=rs("SQtr1")%>&nbsp;</TD>
    I've tried turning off some stuff under Options but no luck, mine still works, so i may need to just sit the machines side by side
    Rebelle, August 27th, 2009 08:37 AM
    Last edited by Rebelle; August 27th, 2009 at 12:06 PM.
    Reply With Quote Reply With Quote
  7. #7
    mehere
    mehere is offline
    Super Sarcasm Mistress mehere is a glorious beacon of light mehere is a glorious beacon of light mehere is a glorious beacon of light mehere is a glorious beacon of light mehere is a glorious beacon of light mehere's Avatar
    Join Date
    Mar 2008
    Location
    Wide Awake In Dreamland
    Posts
    830
    Rep Power
    8

    couldn't tell you ... if it works on yours and it's not working on his, it would appear to be some setting, but don't know which one(s).
    mehere, August 27th, 2009 01:53 PM
    Quote of the Month:
    INSIGHT: When the going gets tough, the tough get going. The smart left a long time ago.

    Questions to Ponder:
    Are people more violently opposed to fur rather than leather because it's much easier to harass rich women than motorcycle gangs?

    iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
    copyright © 2008 sbenj69

    Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.
    Reply With Quote Reply With Quote
  8. #8
    Lauramc
    Lauramc is offline
    I like Data Cubes too... Lauramc has a spectacular aura about Lauramc has a spectacular aura about Lauramc's Avatar
    Join Date
    Mar 2008
    Location
    Far Far Away
    Posts
    387
    Real Name
    Laura
    Rep Power
    5

    The ONLY other thing I can think of that affects the ability to sum is manual or automatic calculation. Make sure it is set to automatically calculate. An easy way to check this is press F9 and see if it works all of the sudden.
    Lauramc, August 27th, 2009 01:56 PM
    "The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS
    Reply With Quote Reply With Quote
  9. #9
    Wolffy
    Wolffy is offline
    Wolfmaster Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy's Avatar
    Join Date
    Mar 2008
    Location
    Peoria, IL
    Posts
    2,386
    Blog Entries
    5
    Real Name
    Wolff
    Rep Power
    15

    Well heck, does he have the same browser version as you? That which works under IE6 may not under IE8 or FF.
    Wolffy, August 27th, 2009 02:51 PM
    Wolffy
    .-- ----- ..-. ..-. -.--
     Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.
    Reply With Quote Reply With Quote
  10. #10
    Rebelle
    Rebelle is offline
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Hey W0lffy,

    We should all have the same version because we're not allowed to upgrade, etc. as our machines are monitored closely.

    But this is when we are opening the file in excel (.xls).
    Rebelle, August 27th, 2009 03:04 PM
    Reply With Quote Reply With Quote
+ Reply to Thread
Page 1 of 2 1 2 LastLast
« Previous Thread | Next Thread »

Similar Threads

  1. help setting up questionnaire database
    By peebman2000 in forum Database Design Help
    Replies: 23
    Last Post: February 10th, 2009, 08:11 PM
  2. Problem setting up a query with Distinct
    By grae.uk in forum SQL Development
    Replies: 14
    Last Post: October 20th, 2008, 10:24 AM
  3. Setting target of Master Page form
    By richyrich in forum .NET Development
    Replies: 2
    Last Post: September 9th, 2008, 07:53 AM
  4. excel to access need macro to find space
    By peebman2000 in forum Microsoft Access
    Replies: 6
    Last Post: August 28th, 2008, 12:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


SEO by vBSEO