Collage with connection

Solved
guerando Posted messages 364 Status Member -  
guerando Posted messages 364 Status Member -
Hello everyone,

For years, I've been using copy/paste with linking from Excel (2016) to Word (2016) and it worked very well.
Today, every time I paste with a link in Word, it closes my Excel file... Considering I have about a hundred of these pastes to do, it makes me lose a lot of time.
When I create a new Word or Excel file, it works perfectly. Similarly, if I open the right files on another computer, it works just fine (we work in a network and the files are on a server).

I've turned the computer off and on again, but nothing works.
Can you help me?

Thank you in advance.

1 answer

Fahora Posted messages 949 Status Member 68
 
Hello,

Check that there is nothing that could close the file in the VBA.
(Shortcut Alt + F11)

Best regards,

Our only limits are those we impose on ourselves.
Politeness and a thank you do not hurt. There is a button for "Resolved" to confirm that your problem is no longer one. Fahora
0
guerando Posted messages 364 Status Member 6
 
Hello Fahora, and thank you for your help,

I just pressed alt + f11 and I have no macros...
0
guerando Posted messages 364 Status Member 6
 
always on the same file I have another issue: here is the question posted just now, there must be a link ... :
I am using Excel 2016, I am working on a large file with quite a few formulas. Until now I had no problem, but now when I enter numbers into my tables, and although the sum formula exists, I have to go to the formula and press enter for it to update and perform the addition...

What is happening?

(I have closed and reopened the file and the computer)
Thank you for your help
0
Fahora Posted messages 949 Status Member 68
 
For this last question:

File > Options > Formulas > Workbook calculation: Automatic
0
guerando Posted messages 364 Status Member 6
 
Yes!! Great, thank you, and it solves all my problems!!! (connections...)
Phew, thank you, thank you

Have a good day
0