Como Trabalhar com Planilhas Compartilhadas no Excel

Há um recurso muito útil e interessante no Excel que pode aumentar significativamente a produtividade de determinadas pessoas que necessitem trabalhar em conjunto em uma mesma planilha: o recurso de planilhas compartilhadas. Esse recurso pode ser utilizado principalmente por pessoas que estão trabalhando numa rede doméstica ou corporativa, sem exceção.

Como funciona uma planilha compartilhada no Excel?

O recurso de planilha compartilhada funciona de maneira bem simples: Ao se compartilhar uma planilha, essa planilha pode ser utilizada por várias pessoas ao mesmo tempo, e sempre que o trabalho realizado na planilha for salvo, tal trabalho será visto pelos demais editores da planilha.

Realmente esse recurso é muito útil principalmente quando há a necessidade de edição rápida por vários usuários da planilha.

Como ativar o recurso de planilha compartilhada?

Também é bem simples: Clique na opção Revisão na barra de menus do Excel

Menu Revisão no Excel

Clique na imagem para ampliar

Após entrar na opção Revisão, clique no botão Compartilhar Pasta de Trabalho

 

Opção Compartilhar Pasta de Trabalho no Excel

Clique na imagem para ampliar

Aparecerá uma janela conforme a seguir:

Opções da janela para compartilhar pasta de trabalho

Clique na imagem para ampliar

Ao clicar na opção marcada em amarelo será ativada a opção de pasta compartilhada. A caixa embaixo da opção mostra o usuário para o qual a pasta está com uso exclusivo. Na guia avançadas há várias opções que, por padrão, são deixadas ativadas e são muito importantes, conforme lista abaixo:

  • Manter histórico de alterações por NN dias: O valor de NN é o número de dias a manter o histórico (o padrão é 30), e é importante para saber quem alterou a planilha e quando.
  • Atualizar alterações: Por padrão é marcada a opção Quando o arquivo for salvo, porém, pode ser escolhida a opção Automaticamente a NN minutos (NN é um valor de minutos a configurar). Essa opção é interessante de ser utilizada pois evita que se altere demasiadamente uma planilha sem saber o que outros usuários estão alterando.
  • Alterações conflitantes entre usuários: A opção Confirmar quais alterações deverão prevalecer é selecionada por padrão, e a sugestão é que essa opção seja utilizada, pois assim alterações num mesmo espaço da planilha poderão se escolhidas antes do seu salvamento.

Como sei se a planilha está compartilhada?

Basta olhar na barra título do Excel, e no lado direito do nome do arquivo aparecerá a palavra [Compartilhado].

Mostre-me o funcionamento!

Quando a planilha for salva aparecerá a seguinte mensagem: A pasta de trabalho foi atualizada com alterações salvas por outros usuários. Abaixo temos um exemplo da exibição de alteração feita por outro usuário:

Resultado da alteração de planilha compartilhada

Clique na imagem para ampliar

Nesse exemplo o Usuário 1 alterou a planilha e salvou; posteriormente, o Usuário 2 alterou o texto digitado pelo Usuário 1 e também salvou. Na célula alterada surgirá um triângulo verde no canto superior esquerdo, indicando que há um comentário baseado na alteração feita por outro usuário.

Gostou da dica?

Então assine nosso feed/RSS e siga-nos no twitter! E muito obrigado pela visita 🙂

Fonte do logo do Excel: dashboardnoexcel.blogspot.com

205 pensou em “Como Trabalhar com Planilhas Compartilhadas no Excel

      • Olá Iúri..fiz os procedimentos, exatos como estão aí..mas ele ao invés de incorporar as inserções feitas pelos diferentes usuários, ele me cria uma planilha em conflito!

        Será que é porque a planilha está em modo de compatibilidade? Pois no nome do Arquivo está, o nome da planilha, {Compartilhado}{Modo de Compatibilidade}

  1. Pingback: Tweets that mention Como Trabalhar com Planilhas Compartilhadas no Excel -- Topsy.com

  2. Olá Iúri,

    Gostei muito da postagem, para mim será realmente muito útil.

    Gostaria de somente fazer uma pergunta, sabe se este recurso esta no pacote Office 2003?

    Abraço!

    • Olá Matheus,

      Que bom que gostou do post 🙂

      Esse recurso também existe no Office 2003. Para acessá-lo vá no menu “Ferramentas > Compartilhar pasta de trabalho”, e a partir daí o procedimento é o mesmo.

      Um abraço.

    • Que bom que você já testou BSA! Também já utilizei algumas vezes, e esse recurso em algumas vezes tira mesmo a gente do aperto.

      Um abraço.

  3. Excelente……A muito tempo estava em busca dessa informação…muito obrigado por compartilhar essa informação, pois sera de grande utilidade no meu serviço…grato!
    Att
    Hugo Lemos

  4. OLÁ IURI,
    TENHO UMA PLANILHA QUE CONTEN DADOS XML ( MENU “FORMATAR COMO TABELA” [ESTILO MEDIO 15] E ELA NÃO PERMITE COMPARTILHAR. É POSSIVEL CONVERTER ESSES DADOS XML SEM ALTERAR OS DADOS E FORMATAÇÃO DA PLANILHA?
    OBRIGADO.

    • Olá André,

      Estava analisando o uso de planilha com dados XML e o compartilhamento no Excel, e realmente não é possível trabalhar com planilhas XML compartilhadas.

      Se você abrir essa planilha com dados XML e salvar como uma planilha Excel (com a extensão .xlsx, por exemplo), você manterá os dados (linhas/colunas) quando da abertura da planilha – isso também inclui a formatação. Faça um teste e depois retorne com um comentário.

      Um abraço.

  5. Pingback: A Falta de Tempo Acaba com a Criatividade | Blog Simples Assim...

    • Olá Waldeth,

      Em breve publicarei um post sobre tabelas dinâmicas, só que esse será um pouco mais demorado porque elaborar exemplos para esse post levará um pouco mais de tempo. Obrigado pela sugestão 🙂

      Um abraço.

  6. Olá, já trabalhei com este tipo de recurso antes, é muito eficiente tal como vários outros no pacote Office que a maioria dos usuários desconhece. Possuo um blog endsub.tumblr.com/ de dicas sobre alguns recursos no Excel, comecei recentemente mas creio que é bem consistente. Depois faça me uma visita.

  7. Execelente dica, mas aqui onde estou utilizando a planilha, eu preciso saber qual usuário alimentou cada linha. É possível obter esta informação?

  8. Olá camaradas, por acaso existe um numero máximo de pessoas permitidas para utilizar a planilha compartilhada simultaneamente ?

    Digo isso pois tenho uma planilha atualizada e erros como o de baixo ocorrem 🙁

    is locked for editing by “another user”

  9. Olá,
    Gostaria de esclarecer uma dúvida:
    Trabalho com planilha compartilhada por 6 pessoas. Ultimamente anda ocorrendo um erro muito grave. Quando alguém lança uma informação em uma determinada linha, esta informação vai parar em outra linha que não tem a ver com aquela.
    Alguém tem idéia do que possa ser?

  10. Mas se a versão do Excel dos computadores na rede forem diferentes entre si, vai corromper o arquivo.

  11. Quando compartilho uma planilha, ela não permite mais que sejam inseridos objetos ou hiperlinks. Tem algum jeito para isso ? Grato.

  12. Boa tarde senhores, eu utilizo esse compartilhamento de planilhas para expor gráficos na minha indústria, gostaria de saber como atualizo da minha sala. Ex.
    Minha planilha tem 10 plans, sendo 9 de informações e a última (10) com o gráfico. Essa última fica em exibição na indústria, só que toda a vez q atualizo as 9 planilhas aqui na minha sala o gráfico atualiza aqui, mas a plan10 que expoe o gráfico não atualiza precisa ir lá, trocar de plan e voltar na 10 pra atualizar! Existe algum método que fica automático isso?
    Obrigado

  13. Boa Tarde! Eu trabalho em uma Clínica e gostaria de criar uma agenda para a marcação de exames pelo Excel, sendo que tenho 2 computadores na recepção, teria como deixar no modo de compartilhamento sendo em 2 computadores diferentes?

  14. Como faço o compartilhamento de pastas no excel starter 2010?

    Outra dúvida: Tem um jeito de compartilhar todas as pastas do excel ao mesmo tempo?

  15. A planilha compartilhada é uma maravilha, mas, em meu trabalho utilizo muito inserir imagens na planilha, e, com ela compartilhada o Excel não permite Inserir Imagens, nem mesclar células.
    Você conhece alguma forma de trabalhar com a planilha compartilhada e ainda permitir que adicione imagens e mescle células?

    Grato!

  16. boa tarde,, tenho uma planilha que tem macro , uso em rede (compartilhada) onde varias pessoas tem acesso.
    todoas as vezes que tenho que colocar informação ,tenho que sair da rede compartilhada , desbloquear a planilha para ter acesso e depois bloqueio com senha e coloco compartilhar pasta de trabalho para as outras pessoas ter acesso novamente.

    a pergunta é : consigo desbloquear a planilha ,para fazer as alteração sem precisar desativar compartilhar pasta de trabalho .

  17. Boa tarde.
    Preciso compartilhar uma planilha do EXCEL que contem uma aba com QUERY. Alguém consegue me ajudar?

  18. I actually got into this post. I located it to be fascinating and loaded with exclusive points of interest. I like to read material that makes me believe. Thank you for writing this fantastic content. caedgedgeedbkddc

  19. A person essentially help to make seriously posts I would state. This is the first time I frequented your web page and thus far? I surprised with the research you made to create this particular publish extraordinary. Fantastic job! ddbafedddcdbaaek

  20. I think this is one of the most significant information for me. And i’m glad reading your article. But should remark on some general things, The web site style is wonderful, the articles is really excellent D. Good job, cheers kebgkacdbgekgkad

  21. Neat blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple tweeks would really make my blog jump out. Please let me know where you got your design. Thanks ddkcddeebfddkbdd

  22. Usually I do not read writeup on blogs, nevertheless I wish to say that this writeup extremely forced me to take a look at and do so! Your writing taste has been amazed me. Thanks, really wonderful post. adadedeeedcakaad

  23. I’m curious to uncover out what weblog system youre employing? Im experiencing some small security problems with my latest weblog and Id like to locate something a lot more safeguarded. Do you have any recommendations? edkcccaddgcfadda

  24. É POSSIVEL UTILIZAR ESSE MODO COMPARTILHAMENTO COM VERSÕES DIFERENTE DO EXCEL EM PONTOS DIFERENTES.

  25. Very interesting subject , appreciate it for posting . All human beings should try to learn before they die what they are running from, and to, and why. by James Thurber.

  26. Aw, this was a very nice post. In thought I want to put in writing like this moreover taking time and actual effort to make an excellent article but what can I say I procrastinate alot and not at all seem to get something done.

  27. Compartilho a planilha, porém quando o outro usuário abre, o arquivo só fica como somente leitura.

    Como proceder?

  28. I like the helpful information you provide in your articles. Ill bookmark your weblog and check again here regularly. I’m quite certain I will learn plenty of new stuff right here! Good luck for the next!

  29. Hey there! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good results. If you know of any please share. Thank you!

  30. Fantastic beat ! I wish to apprentice while you amend your website, how can i subscribe for a blog web site? The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear concept

  31. Link exchange is nothing else but it is just placing the other persons weblog link on your page at proper place and other person will also do similar in support of you.

  32. Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how can we communicate?

  33. Hi, Neat post. There is a problem with your web site in internet explorer, would check this IE still is the market leader and a large portion of people will miss your magnificent writing because of this problem.

  34. I do trust all of the ideas you’ve presented in your post. They’re very convincing and can certainly work. Nonetheless, the posts are very short for beginners. May just you please lengthen them a bit from next time? Thanks for the post.

  35. What’s Happening i’m new to this, I stumbled upon this I have discovered It positively helpful and it has aided me out loads. I hope to contribute &amp help other users like its helped me. Good job.

  36. I got what you intend, thankyou for putting up.Woh I am lucky to find this website through google. Being intelligent is not a felony, but most societies evaluate it as at least a misdemeanor. by Lazarus Long.

  37. I think this is one of the most important info for me. And i am glad reading your article. But wanna remark on few general things, The web site style is ideal, the articles is really excellent D. Good job, cheers

  38. with people like one to grant visibly all of that numerous populaces would am inflicted with sold for electronic ebook to create selected jumps in favor of their unique terminate, mainly right away

  39. I am now not certain the place you’re getting your info, however good topic. I needs to spend some time learning more or figuring out more. Thank you for magnificent info I was on the lookout for this information for my mission.

  40. Spot lets start off perform on this writeup, I seriously consider this astounding internet site needs much more consideration. Ill apt to become once again to find out to read considerably a lot more, thank you that information.

  41. I am no longer sure the place you’re getting your info, but great topic. I needs to spend a while studying much more or understanding more. Thanks for wonderful info I was on the lookout for this info for my mission.

  42. Today, while I was at work, my sister stole my apple ipad and tested to see if it can survive a 30 foot drop, just so she can be a youtube sensation. My apple ipad is now broken and she has 83 views. I know this is entirely off topic but I had to share it with someone!

  43. Merely a smiling visitor here to share the adore , btw outstanding style. Audacity, more audacity and always audacity. by Georges Jacques Danton.

  44. Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how can we communicate?

  45. Im genuinely enjoying the style and layout of one’s website. Its a very uncomplicated on the eyes which makes it a great deal much more enjoyable for me to come here and pay a visit to far more typically. Did you hire out a designer to make your theme? Excellent perform!

  46. Hello there! This post could not be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this page to him. Fairly certain he will have a good read. Thank you for sharing!

  47. Wow, wonderful blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is excellent, as well as the content!

  48. Hi there! Would you mind if I share your blog with my myspace group? There’s a lot of people that I think would really appreciate your content. Please let me know. Many thanks

  49. hi!,I love your writing so much! share we communicate more approximately your post on AOL? I need an expert in this space to resolve my problem. Maybe that’s you! Looking forward to peer you.

  50. Hi there, just became aware of your blog through Google, and found that it’s truly informative. Im gonna watch out for brussels. I will appreciate if you continue this in future. Many people will be benefited from your writing. Cheers!

  51. I’m really enjoying the themedesign of your website. Do you ever run into any internet browser compatibility issues? A handful of my blog audience have complained about my site not operating correctly in Explorer but looks great in Firefox. Do you have any solutions to help fix this problem?

  52. Aw, this was a very nice post. In thought I want to put in writing like this moreover taking time and actual effort to make an excellent article but what can I say I procrastinate alot and not at all seem to get something done.

  53. Normally I do not read post on blogs, but I wish to say that this writeup very compelled me to try and do it! Your writing style has been surprised me. Thanks, quite great article.

  54. Eu consigo compartilhar a mesma planilha e as filtrar o que cada um pode editar, sem que todos tenham acesso a todas as células da planilha?

  55. Olá. Parabéns pela planilha.

    No caso do compartilhamento, esse arquivo deve estar em um servidor, correto ?

  56. This is really attentiongrabbing, You’re a very professional blogger. I have joined your rss feed and sit up for in search of extra of your fantastic post. Also, I have shared your site in my social networks!

  57. I do trust all of the ideas you’ve presented in your post. They’re very convincing and can certainly work. Nonetheless, the posts are very short for beginners. May just you please lengthen them a bit from next time? Thanks for the post.

  58. Good day! I know this is kind of off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having problems finding one? Thanks a lot!

  59. Hi there, just became aware of your blog through Google, and found that it is really informative. Im going to watch out for brussels. Ill be grateful if you continue this in future. Lots of people will be benefited from your writing. Cheers!

  60. Good day! Do you know if they make any plugins to safeguard against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any recommendations?

  61. I feel that is among the so much significant information for me. And i’m glad studying your article. However should observation on few general issues, The website taste is ideal, the articles is in point of fact excellent D. Just right activity, cheers

  62. Hello, Neat post. There is a problem with your website in web explorer, may check this IE still is the market leader and a large component of folks will leave out your magnificent writing because of this problem.

  63. A person essentially help to make seriously posts I would state. This is the first time I frequented your web page and thus far? I surprised with the research you made to create this particular publish extraordinary. Fantastic job!

  64. I just couldn’t depart your site before suggesting that I actually enjoyed the standard information a person provide for your visitors? Is gonna be back often in order to check up on new posts

  65. Ultimately, a dilemma that I’m passionate about. I have looked for data of this caliber for the previous various hours. Your internet site is greatly appreciated.

  66. I am just seeming both for blog sites which give independent, nutritious commentary on all difficulties or blogging sites which have a liberal or droppedwing slant. Thank you..

  67. Hi there, just became aware of your blog through Google, and found that it’s truly informative. Im gonna watch out for brussels. I will appreciate if you continue this in future. Many people will be benefited from your writing. Cheers!

  68. Good day! Do you know if they make any plugins to safeguard against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any recommendations?

  69. I do not even know how I stopped up here, however I assumed this put up was good. I do not recognise who you are however definitely you’re going to a wellknown blogger for those who are not already

  70. Thanks a bunch for sharing this with all of us you actually realize what you’re talking approximately! Bookmarked. Kindly also visit my web site . We will have a hyperlink exchange arrangement among us!

  71. certainly like your website however you have to check the spelling on several of your posts. Many of them are rife with spelling problems and I to find it very troublesome to inform the truth nevertheless I will surely come back again.

  72. hi!,I love your writing so much! share we communicate more approximately your post on AOL? I need an expert in this space to resolve my problem. Maybe that’s you! Looking forward to peer you.

  73. whoah this blog is excellent i really like reading your articles. Stay up the good work! You already know, many persons are looking around for this info, you could help them greatly.

  74. I’m not sure exactly why but this weblog is loading very slow for me. Is anyone else having this problem or is it a problem on my end? I’ll check back later and see if the problem still exists.

  75. An fascinating dialogue is value comment. I believe that it is best to write more on this matter, it might not be a taboo topic but generally individuals are not sufficient to talk on such topics. To the next. Cheers

  76. I’m trying to find sites that have already fantastic useful information on what’s popular and what is the optimum makeup products is..

  77. Link exchange is nothing else but it is just placing the other persons weblog link on your page at proper place and other person will also do similar in support of you.

  78. Hey very nice website!! Man .. Beautiful .. Amazing .. I’ll bookmark your website and take the feeds alsoI’m happy to find numerous useful information here in the post, we need work out more techniques in this regard, thanks for sharing. . . . . .

  79. Hey very nice web site!! Man.. Beautiful.. Wonderful.. I’ll bookmark your web site and take the feeds alsoKI am satisfied to seek out a lot of helpful information here in the publish, we want work out extra techniques in this regard, thank you for sharing

  80. Hey very cool blog!! Guy.. Beautiful.. Wonderful.. I will bookmark your website and take the feeds additionallyKI am satisfied to search out numerous useful information right here in the publish, we want develop more techniques on this regard, thank you for sharing

  81. requirements. Recognitions pro suggestion like operative, balanced, explanatory as well as moreover exuberance thinkings about this issue to Gloria.

  82. I do not even know how I stopped up here, however I assumed this put up was good. I do not recognise who you are however definitely you’re going to a wellknown blogger for those who are not already

  83. Hello, Neat post. There is a problem with your website in web explorer, may check this IE still is the market leader and a large component of folks will leave out your magnificent writing because of this problem.

  84. I like what you guys are up too. Such smart work and reporting! Carry on the excellent works guys Ive incorporated you guys to my blogroll. I think it’ll improve the value of my website

  85. Thank you for the sensible critique. Me &amp my neighbor were just preparing to do a little research about this. We got a grab a book from our local library but I think I learned more from this post. I am very glad to see such excellent info being shared freely out there.

  86. Hello there, I discovered your website by the use of Google while looking for a related subject, your web site came up, it seems good. I have bookmarked it in my google bookmarks.

  87. There are some attentiongrabbing points in time in this article but I dont know if I see all of them heart to heart. There may be some validity however I will take maintain opinion until I look into it further. Good article , thanks and we would like extra! Added to FeedBurner as properly

  88. You’re so interesting! I don’t think I have read anything like this before. So wonderful to discover somebody with some unique thoughts on this subject matter. Seriously.. thank you for starting this up. This website is one thing that is needed on the internet, someone with a bit of originality!

  89. Hi, Neat post. There’s a problem with your website in internet explorer, would test this IE still is the market leader and a good portion of people will miss your great writing due to this problem.

  90. I just like the helpful info you supply on your articles. I will bookmark your blog and take a look at once more here regularly. I’m somewhat sure Ill learn a lot of new stuff right right here! Best of luck for the following!

  91. Good post. I study something more challenging on completely different blogs everyday. It is going to all the time be stimulating to learn content material from different writers and practice somewhat one thing from their store. I

  92. omg! cant picture how quick time pass, after August, ber months time already and Setempber may be the 1st Christmas season in my location, I genuinely really like it!

  93. When I originally commented I clicked the Notify me when new comments are added checkbox and now every time a comment is added I get 4 emails using the same comment. Is there any way you may take away me from that service? Thanks!

  94. Attractive section of content. I just stumbled upon your website and in accession capital to assert that I get in fact enjoyed account your blog posts. Any way Ill be subscribing to your feeds and even I achievement you access consistently rapidly.

  95. Gostei das dicas mais ainda por ter imagens ilustrando, tem sites que somente explica com textois, nesse site a explicação é completa com textos e imagens, parabéns !!

Deixe um comentário para cialis Cancelar resposta

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *