Ok
What has happened is that you have two instances of excel open.
Each instance of windows works as a completely separate program.
They do not interact.
To avoid this.
Open one excel file.
Then open ever other file using the file open function within excel.
Bookmarks