an excel question

  sunny staines 14:18 11 May 2008
Locked

i have an excel spread sheet on the pc and if someone sends an updated speadsheet by email how do i get it to replace the outdated figures on the spreadsheet on the pc.

  VoG II 14:39 11 May 2008

See the FE's suggestion click here

  Taff™ 14:43 11 May 2008

Depends if you have alterations you wish to keep on your original version. I would save the new e-mailed version with a different file name to my HDD. Open that spreadsheet and then either copy and paste the data to my original. Option two would be to rename sheets and copy them to my original perhaps resetting the links to the new data. It depends on how much has changed really.

  crosstrainer 15:00 11 May 2008

I would agree with Taff™, you may wish to refer to the older data at some future point, I would keep the old ones, and name the updated versions by logical names you can easily recognise. That way you have the old data to refer to if required.

  sunny staines 15:17 11 May 2008

VoG™,Taff™,crosstrainer.

thanks i read though the linked thread and decided to save to same folder so it overwrites the pre version. I do not need old figures.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?