Links between Visio and Excel... copying files / templating - Microsoft Community

-

please advise on best method distributing linked pair of documents (visio , excel) template use in our office.

i have tried following:

  1. linking 2 documents - links broken when files moved, renamed, or 'saved as.'
  2. embedding spreadsheet visio , linking embedded worksheet - links updated sporadically.  have not found way force.
  3. creating visio template including linked, embedded excel worksheet - templating works, same issue above
  4. creating smart shapes in visio replace excel links, , linking cells shape fields - not seem work using embedded documents

please advise.

hi chris,

can insert excel workbook visio object:
in visio, click "insert" > "object" > "microsoft excel worksheet" > "create file" > "browse".
go "file" > "save as" > choose .vstx in "save type".

regards,
james


Office / Visio / Windows 10 / Office 365 for business



Comments

Post a Comment

Popular posts from this blog

Can't Sign-in to OneDrive - Microsoft Community

-
Image
can't sign-in onedrive account surfacepro laptop last 2 weeks. have no problem signing-in , syncing on desktop pc. below error message error code: 0x8004def7. when access onedrive.com surfacepro try fix it, couldn't find error. appreciate help. thanks. hi thomas, a few possible reasons can cause error message. identify cause of problem, know following information: are signing in onedrive sync app or office app word or excel? have tried signing in using web browser on https://onedrive.live.com/ ? have made changes computer before experiencing issue? what troubleshooting steps have tried far? in meantime, suggest make sure have latest windows updates . keeping windows up-to-date ensures have latest security updates , fixes. for additional troubleshooting steps can perform, may refer following link: fix onedrive sync problems . we wait response. OneDrive
Read more

Shared mailbox permissions - Microsoft Community

-
Image
hi we have shared mailbox shared user , want use tasks of shared mailbox not updating when make changes. there solution this? hi karabotladi, when shared shared mailbox user, did grant permissions him? if share task user, on permissions tab, in name box, click name of person access want change. under permissions, in permission level list, choose permission level. if share shared mailbox user, use admin account log exchange admin center > recipients> shared> select , double click it> mailbox delegation> add user full access list. regards, vanessa Office / Outlook / Windows 10 / Office 365 for business
Read more

Outlook 2016 for Mac - Multiple Issues, Error 17884 - Microsoft Community

-
working mac users @ business. have few issues outlook 2016 not seem have clear cut solutions can find searching community. new emails - messages sporadically go straight outbox after being sent, not send until user exits re-opens outlook, work after multiple restarts. error code see corresponding 17884 sync status - thousands of items have yet synced. sync status show proper statistics items syncing, statistics change 'server busy' , have no idea if still syncing in background or hung up. using 'sync folder' or 'send & receive' stack more items sync status window no progress made. connection window in bottom right corner - upon start up, display 'not connected'. can leave outlook open prolonged period of time , never change, if change status of outlook online offline multiple times in tools window. so far have rebuilt profile scratch within outlook tried opening outlook on multiple wifi networks tried ope
Read more