are you saving both the files in a same folder. You can try this with vba
On Mon, Mar 10, 2014 at 11:59 PM, Caroline Campos <caroline....@gmail.com>wrote: > Olá Ricardo. > > Na verdade eu preciso manter dois arquivos atualizados ao mesmo tempo, vou > atualizar somente a pasta 1, e a pasta 2 deve conter sempre as mesmas > celulas e dados da pasta 1, ela deve ser atualizada toda vez que salvo o > meu arquivo original. > Só isso, as celulas devem conter vinculo, porém mesmo colando com vínculo, > quando adiciono qualquer tipo de hyperlink no arquivo pasta 1, o meu > arquivo pasta 2 não cria este mesmo hyperlink, quero que os dois arquivos > sejam sempre identicos e irei atualizar somente a pasta 1. > Porém preciso adicionar hyperlink nas células conforme for trabalhando na > pasta original. > Ele até cola o vínculo, cola o hyperlink, mas se eu precisar altera-lo, já > não mantém mais vínculo de hyperlink, só de texto! > > Aguardo sua ajuda!! > Muito Obrigada! > > > > > > *Att. Caroline Campos (21) 8102-4893* > > *Preserve o Meio Ambiente* > *Por favor, pense em sua responsabilidade * > *e compromisso com o Meio Ambiente, * > *antes de imprimir qualquer documento.* > > > > > > > > > 2014-03-10 14:29 GMT-03:00 Ricardo(R) <ricardo...@gmail.com>: > > Olá carolina boa tarde, >> >> Pelo que eu entendi, voce criou um link de uma imagem na pasta1 e colou o >> link na pasta2 e voce quer que ao clicar no link da pasta2 abra a pasta1? >> >> Caso seja isso, ao colar na pasta2, com o botão direito do mouse, siga a >> opção COLAR ESPECIAL, e Depois, mais embaixo: COLAR ESPECIAL, vai abrir >> uma janela com varias opões, ai procure na parte de baixo do lado esquerdo >> o botão "colar vinculo". >> >> Espero ter ajudado. >> >> >> Basole. >> >> >> >> 2014-03-10 8:43 GMT-03:00 Caroline Campos <caroline....@gmail.com>: >> >>> Ok, the samples are attached, but you can see that the files are linked, >>> but when i insert a hyperlink in the principal worksheet (pasta1), the >>> other doesn't updates. >>> Thanks for your help! >>> >>> >>> >>> *Att. Caroline Campos (21) 8102-4893 <%2821%29%208102-4893>* >>> >>> *Preserve o Meio Ambiente* >>> *Por favor, pense em sua responsabilidade * >>> *e compromisso com o Meio Ambiente, * >>> *antes de imprimir qualquer documento.* >>> >>> >>> >>> >>> >>> >>> >>> >>> 2014-03-08 10:25 GMT-03:00 ashish koul <koul.ash...@gmail.com>: >>> >>>> you can use =HYPERLINK formula. Can you please share a sample file >>>> >>>> >>>> On Thu, Mar 6, 2014 at 5:20 PM, Caroline Campos <caroline....@gmail.com >>>> > wrote: >>>> >>>>> I have two worksheets and I linked the cells to change automatically, >>>>> but when I insert a hyperlink in the cell of the original worksheet, it >>>>> does not change the other worksheet that should be updated. >>>>> Copying and pasting the cells, it works, but when i update the >>>>> hiperlink, it doesn't >>>>> So, I need too link the cells, and when updating, change the hiperlink >>>>> too. >>>>> Somebody help me? Thank you. >>>>> >>>>> -- >>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> 2) Don't post a question in the thread of another member. >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> 5) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>> and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to excel-macros+unsubscr...@googlegroups.com. >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>> >>>> >>>> >>>> -- >>>> *Regards* >>>> >>>> *Ashish Koul* >>>> >>>> >>>> *Visit* >>>> http://www.excelvbamacros.in >>>> Like Us on >>>> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/151803898222297> >>>> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> >>>> >>>> >>>> P Before printing, think about the environment. >>>> >>>> >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/excel-macros/RkL2lK2tZWU/unsubscribe. >>>> To unsubscribe from this group and all its topics, send an email to >>>> excel-macros+unsubscr...@googlegroups.com. >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/excel-macros/RkL2lK2tZWU/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/151803898222297> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
