Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Native Saving (2003)

    I have a user who converted Elite data, (our billing system), and saved the file to a network drive. When opening Excel, she ran a wizard to convert the billing data into Excel, which worked. When she saves the converted data in Excel, it does not save back to the network drive. Does Excel save to a temp directory on the C: drive? I ran a search on her C: drive for *.xls, but didn't find the file. I know that if you open an email attachment and save the attachment, it saves to a temp directory, so I'm thinking Excel may do the same thing. Any suggestions would be appreciated. Thanks!! <img src=/S/devil.gif border=0 alt=devil width=15 height=15>

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Native Saving (2003)

    If your user performs a SaveAs, she will be prompted for the location to save to. If you open a file from a location and save it, it will save back to that same location.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Native Saving (2003)

    She didn't do a save as - usually that is the process; in this case though, her document wasn't saving back to the original file location; so I'm not sure where it was saving to. Thanks for getting back to me Rory

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Native Saving (2003)

    What type of file was it (.txt, .csv or something else) and how did she open it? From the File-Open dialog or by double-clicking in Explorer?
    If you go through the import wizard, then when you click Save, you should be prompted about features being incompatible with the current format and you would have to choose yes to override that, in which cas ethe file would be saved in the same format as it was originally - so if it was a text file, it will be saved as a text file by default, not as a Workbook.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Native Saving (2003)

    Cannot tell what file type it is; performing File, Local Open; browsing to the file, then letting the wizard run. Not prompted to save, just Finish at the end of the wizard. This opens the file in Excel. If you make changes and hit File, Save, I cannot find where this document saves back to. Normally, we would do File, Save As to save back to our document management system. But, my user didn't do this, just File, Save. So I'm not sure what directory it was saved back to. It's definitely not saving back to the network directory where the file originated from. That why I thought there might be a local directory on C: that it was saving to... <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>
    Attached Images Attached Images

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Native Saving (2003)

    What extension does the file have? It sounds very much like a text file to me, in which case saving would save it as a text file back to its original location. If the changes made were incompatible with text files, they would be lost, but, as I said, you should get warned before this happens. However, with a DMS involved, I can't be as sure that this is what would happen, since most of them hijack the way Office works in strange and unpredictable ways! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    If you have the original file, I think you'd have to just open it and start again...
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Native Saving (2003)

    That what we ended up doing, re-importing the file into Excel; then saving to our DMS to make sure we had the changes. Guess the other one is lost in space... <img src=/S/alien.gif border=0 alt=alien width=14 height=15>

Posting Permissions

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