Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Linked Excel-Excel and Powerpoint-Excel are slow to update.?

I have linked Excel-Excel(source) and Powerpoint-Excel (source) files stored on a shared server. When I have the source and destination files both open on my dektop the destination file updates immediately when a change is made in the source file (works like a charm!).

However, when the same files are open at different workstations (User1 at one workstation and User2 at a second workstation) they do NOT update dynamically and I have to go thru gyrations to effect the update. Even saving the changes to the source file and updating the links in the destination file doesn't get my updates right away. This is not convenient because I want the users to view the updates passively (and immediately). Note that Automatic Update is set correctly.

2 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    If you wish both users to work on the Excel file simultaneously, you have to share the Excel file and I think Microsoft uses Groove to do that.

  • ?
    Lv 4
    5 years ago

    If the information you employ are the comparable ones every day, you ought to objective this: Create a clean folder on your laptop rename it some thing suitable like "Importan scientific medical doctors" or some thing "known scientific medical doctors" etc. click and carry the stunning mouse button down on it, then drag over to the beginning up button, watch for the beginning up menu to come again up, pass as much as All classes (or classes on some setups), watch for that menu to amplify, then as you're dragging up that record you may get a horizontal bar performing. At that factor, enable pass of the stunning mouse button. a touch menu could pop up - opt for "flow" next time you pass to navigate for a checklist, click and carry the stunning mouse button on it, drag over to the beginning up menu, up into your new folder, launch the stunning mouse button. yet another menu could pop up, yet this time with an option to "create a shortcut right here". opt for this. Over the direction of an afternoon you've got outfitted up lots of the records you employ commonly in there. the coolest thing approximately it extremely is that the shortcuts will constantly stay in there

Still have questions? Get your answers by asking now.