computer Forum

Connect two Excel files / Problem: Connected cell and continue linking

Question: Connect two Excel files / Problem: Connected cell and continue linking

I would like to link these two tables together and solve those in this problem? File no. 2 should have the mean values ​​If I have: File No. 1 includes temperature values ​​at different times.

The two images in Appendix abstract the content and the question, however, eg if I map each field individually from file no. 1 per hour. How can I thank you in advance!
Hi all,
I have two excel files (actually there are several thousand lines with annotations in my present project).

Many greetings and the file no. 1 established mean values ​​in file no. 2 insert. Click on Sandra, I can make the link.

Topicality 100%
Recommended solution: Connect two Excel files / Problem: Connected cell and continue linking

I recommend downloading Fortect. It is a repair tool that can fix many Windows problems automatically.

You can download it from here Download Fortect. (This link starts a download of Fortect.)

Topicality 78.72%

I liked the EXEL program in a cell then press ALT + ENTER

Write "Paul", and write something among each other,
as :
Paul
Musterman
how do I do that ?

Topicality 71.75%

Which Windows does the server drive to get into the start menu? Under Startmenu the menu is meant that you immediately?

Simply pulling in does not work; because I get such a no-stop sign.

Hi people,

is it possible to see a link to an excel file after having pressed the windows button at the bottom left ...

Topicality 70.93%






How do I get this regulated in Word?

 

Topicality 70.93%

Basically, I liked a "master" document which had content for your references.

Dear Community,

I work with Http://www.excel-helfer.de/zellbezug...erstellen.html

automatically copied to the "slave" documents at the desired location. Approach?

The constant opening of the individual documents eg As Thank you very much costs in the sum of time. So many Word and Excel documents.

Topicality 70.93%

There it is said you could do this with this (or another) file
2. Of course, I already have a properties - alternative text

The drop-down list is created in field D10 and linked there via = EMBEDD ("Forms.ComboBox.1"; ""). I have actually already made the addition to the code, now I am missing a drop-down list for selecting countries. In code

You have to search where German "Formulare" is in the "Project Window" as seen here:

https://static1.squarespace.com/stat...ditor+Overview

Does anyone have an idea how to complement. The selection should then be read out, the content of the box is defined.

Hallo,

I have an Excel file in which only the country is in the drop-down list so that it can be selected at all. Look in the VBA Editor under "Forms" or right-click and then under Format Control ...

However, only the following tabs are shown here:
Great - protection - and be processed in VBA code. These I would like to have ways to get entries in a ComboBox:
1. Reference to cells in expanding to another country. little at Google made smart.

Best regards
SSD Turbo



Are there two I can extend the list?

Topicality 70.93%

It does not make sense to drag down here, as otherwise the cell will only be executed on the one formula (SVerweis) if the adjacent cell is filled. This works, but does not know the value 0 and a serial letter was generated. In column A, a predefined variant is selected via drag-drop, in column B concrete. In another table, the total amount is like and can not be reproduced.


Hallo,
For a form letter, I need an Excel spreadsheet, calculated in always automatically when two fields are filled. The counterpart should now be written over SVerweis without the formula being pulled down. Thanks in advance!

Topicality 70.11%

Hello kicker

This does not work for .xls files because the format is too old. LG system: Windows 8.1 64-bit (with all updates) also set the flag. In the memory menu I can save .xlsx, then it will be displayed.

After saving but will save on with the appropriate thumbnail image on my desktop. The following challenge is: I would like to have dedicated XLS files / Excel 2013 (with all updates)

Many Thanks ! Unfortunately, you always have to use the document as the desktop standard XLS icon. Elias

Topicality 68.88%

Can someone help me? The selection "Values", "Formulas" or "Link" does not open, but only the possibility of selecting a wide variety of functions such as Unitext and the like.
Thank you for a new installation
eumex
Link between cells of different files no longer.

Topicality 68.06%

Links on the lie, then it is found by the search. If I have a file directly on the desktop with the search in Windows 10.

1. On Windows 7 the same Explorer window opens again.
2. The desktop options are in the indexing options.

Thanks for your desktop are not found.








Hi all,
two little problems i have found them. When I search for something using the keyboard input, i.e. (Windows key) -> "Search my elements" and then "Explorer", an Explorer window opens with the result. Are these still bugs or have I overlooked a setting somewhere?

If I close this window now, suggestions! * Thumb print *

Read more ...
 

Topicality 66.83%

Some of them are directly on the one that you also have to click on the icon in the system tray. These shortcuts (only they) behave when the files for them are displayed (open?) On the taskbar. The file is only minimized when "Exports" so that it should be opened in a normal window. Access to some script files (cmd and bat for testing command line strings for the VLC).

Can someone tell me why this is due to be opened for editing, unlike Windows 7. With a mouse click on it will then also opened. Because you have minimized in there - and that is then desktop, for others only a link. This behavior is very disturbing, especially in the early days, until you know


Hallo,
I have direct from the desktop and if there is a way to turn it off. MfG, kodela

Then put in the properties of the links for each mode in which the file behind it is opened.

Topicality 65.19%

October

Read more ...
 

Thank you for assistance - sunny greetings S.

Topicality 65.19%

MP4) via properties => crawled but found nothing. A video file for updates

THX
WiiYoshi

 






I put in the file (eg Windows 7 64Bit Ultimate - with the latest is not more.




Hi,

have all Google and the VLC player starts the play.

 

Vlc pulls, the icon is masked and also used but if you know someone open with => VLC player. Then you only need to click on the file, the problem or the symbol of the example

The solution to that? I do not know if you let go of the file with the respective program.

Topicality 63.96%

In general, the data is quite different in file 0 attaches and then runs through to xxx. If there is a hyperlink which can be replaced by clicking on e: \ ...

Changing the drive letter opens the file described in the table. Unfortunately, this is replaced by the new one?

Now I would like to ask you if it is possible that perhaps with search / replace make?

Hello people,

I have the problem that I have created a directory for journals in an Excel spreadsheet. So you "only" had to create a hyperlink, which quasi table no names from the files appear. So to make the old drive letter functional again without much effort.

Unfortunately, this is not an option. Something like c: \ date details, etc. In addition to other information and named ALLERDINGS also in the correct order. Here's an example
Greetings



You can

Topicality 63.55%

a change in folder 1 or So: Does the linkage remain? Folder2 made and saved it in the cloud service folder. I have Win7 installed on a SSD and then using robocopy Apropos.

Has anyone practical experience, like this I have moved the user folders by means of symbolic linkage. Continue reading...
 










Hello, when installing Win7 after the changes takes place). My arguments:
- If I link in an update to Win10? Folder1 is located on the local data carrier C: \, Folder2 -

The question: If that changes a problem, everything will be synchronized (both the file and the links).








Protect a question and a discussion. That was successful because mine (goods fatal, if not ...).
 

So no, my cloud service does not realize this (ie cloud service that has synchronized.) The post is something between on the D: \ and my cloud service folder - on Z: \).

While this may be considered a workaround, I liked the topic. If, in addition to changing symbolic links, you also blame a file directly in the Windows Explorer cloud service folder. find a generic solution (or find that there are none). At the time I had two in ... Continue reading ...

Topicality 61.91%

The missing link of the product can not be installed on my new PC. If applicable, please return Office 2013 home and student and choose instead to enter a PK. Error message: The account you are logged in with is not assigned to this Office product .....

There, the key appears with the MS account for office. Do not do it with me. Thank you for help. If you have a PK they do not go purchased product!

This field gives

Topicality 61.91%

Carlos

 









Quote from mtemp:





Who knows the solution? Click in restart (or log off and on) necessary for it to work.

 

Under XP, this registry entry should allow:

code:
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER \ Software \ Microsoft \ Windows \ CurrentVersion \ Explorer]
"link" = hex: 00,00,00,00
But under win7 / 64 this does not affect me. Who knew was fast lead to the solution ... What should work under XP, at least not works for me under Windows 7:
When creating this field to display it in full size.

Is with me already with the above registry entry - but one is the solution?




Damn, thought, a quick googl-egg of a link I liked to suppress the name of this link in "[filename] - link".

Topicality 61.5%

The tool Alternatively, the Excel Tool Synkronizer (www.synkronizer.com) can be used, which performs this task automatically. All I had to do was know which inventory numbers did not exist on table 2. An inventory number can not be added to table 1 on table 2.

tuts too. There is a mark in table 2. is however subject to a charge. However, these numbers should not automatically from

Watergate

It's about inventory numbers:
Table 1 = ca 5000 inventory numbers
Table 2 = ca 2000 inventory numbers

Now it is best to make a note on table 1 if, for example, the COMPARE function actually looks like this:

= MATCH (! A1; [Datei.xls] Tabelle1 $ A: $ A; 0)

If the function returns a number, the article is in the other file, if not, it is new.

Topicality 60.27%

a way how to include the desktop

Hallo,

since the Windows 10 upgrade in the bar (navigation area) click on desktop and has always seen all the links and files. The logged on user and also in the Explorer (thus also eg in Windows 7 one could get indicated only directly over the direct call (c: \ user \ public \ desktop).

In Save As, Open File or Append File Dialog Dialog), go to Favorites on the left, where you will take both folders.

Users and public shortcuts can be accessed via Windows Explorer? Is there maybe a trick or I think that the "desktop" library has the public / desktop shortcuts for all users.

I have had a "small" problem with the links from the public desktop.

Topicality 58.63%

How to make something at the bottom right of the clock So path also create a link and move it to the star menu. I do not get out yet ...



I would like to be right next to the clock - or for the link ...

So do not use Original Position (Taskbar) - but relocate ...

Sources:
https://www.winboard.org/office/176639-zwei-excel-dateien-verbinden-problem-verbundene-zelle-und-fortfuehrung-der-verknuepfung.html
https://www.drwindows.de/programme-tools/10709-excel-zwei-zeilen-zelle.html
https://www.winboard.org/office/175976-excel-zellen-verbinden-und-die-zusammengefuegte-zelle-kopierbar-machen.html
https://www.computerbase.de/forum/showthread.php?t=1665374
https://www.windows-7-forum.net/threads/formel-in-word-beispiel-wie-in-excel-zelle-a4-soll-zelle-a1-sein.52642/
https://www.computerbase.de/forum/showthread.php?t=1688733
https://www.computerbase.de/forum/showthread.php?t=1721751
https://www.winboard.org/office/172099-excel-automatische-formelberechnung-ausweitung-auf-untere-zelle-wenn-nebenstehende-zelle-gefuell.html
https://www.drwindows.de/windows-8-windows-rt/76458-fehlende-miniaturansicht-windows-8-1-excel-verknuepfung.html
https://www.winboard.org/office/172137-verknuepfung-excel-2007-funktioniert-nach-neu-installation-nicht-mehr.html
http://www.windows-10-forum.com/threads/windows-10-suche-oeffnet-zwei-explorer-fenster-findet-keine-verknuepfung-auf-desktop.7765/
https://www.win-10-forum.de/windows-10-allgemeines/9470-offnen-skript-dateien-ueber-verknuepfung-desktop.html
http://www.windows-10-forum.com/threads/verknuepfung-loescht-schon-vorhandene-dateien-in-einem-ordner.34108/
https://www.windows-7-forum.net/threads/dateien-in-bzw-auf-icons-exe-verknuepfung-ziehen-geht-nicht-mehr.48455/
https://www.computerbase.de/forum/showthread.php?t=1685023
http://www.windows-10-forum.com/threads/ein-problem-mit-cloud-und-symbolischer-verknuepfung.34726/
https://www.winboard.org/office/183106-problem-fehlende-verknuepfung-des-produkt-key-mit-dem-ms-konto-bei-neuinstallation.html
https://www.windows-7-forum.net/threads/verknuepfung-anlegen-ohne-zusatz-verknuepfung.18789/
https://www.drwindows.de/programme-tools/48985-geloest-zwei-excel-dateien-miteinander-vergleichen.html
https://www.computerbase.de/forum/showthread.php?t=1608667
https://www.drwindows.de/windows-10-desktop/134179-taskansicht-schaltflaeche-anzeigen-verknuepfung-icon-verknuepfen.html