#REF! LINK PROBLEM WORKBOOKS SPREADSHEETS NAME CHANGED

Fireduptotwelve

New Member
Joined
Apr 19, 2020
Messages
9
Office Version
  1. 2019
Platform
  1. MacOS
So THIS IS IT.
Came to this big SURPRISE.

IF you interconnect your books, no matrix, just interconnect them one with which other and vice versa (the other way around).
everything will run OK and Smooth as long as if you don’t CHANGE the name on any Spreadsheet you have.

If you change Spreadsheet name, you get REFFED. WHY?
We have reached Mars, several satellites floating around the globe track you via gps to know where you are with centimeters of mistake.

and Microsoft Excel, can’t handle a dynamic spreadsheet name
instead of tracking the name, it should be tracking the page Id Info, IDK man, not the name.
name are meant to be changed when you are creating something.
you add and add.
just to came into this problem when you finish.

I made 2 little workbooks interconnected one to the other and the way around the other to the one.
started linking the cells
started changing spreadsheet names

Each workbook had only 4 cells
workbook 1 : spreadsheet 1 cell one (A1) spreadsheet 2 cell 3 (C1)
workbook 2 : spreadsheet 1 cell two (B2) spreadsheet 2 cell 4 (D1)

then I close one book, named spreadsheets, save and close.
open the other book, message “links bla blah” popped up when openning.
yes connect, or no. Or whatever, do your stuff Excel!!! ain’t rocket science!
changed spreadsheets name, cell values, save, close.

Finally, I get to have =REF!, UNTRACKABLE, JUST REF


WHY IN THE WORLD? Because I changed Spreadsheet names? OHHHHH MYYYYY GOOOOD.

WHY IN THE WORLD? 😂😂😂😂😂😂😂😂😂😂 WHY?
SO NOW EXCEL Can’t Track this thing? 😂
not even added new pages, nothing 😂😂😂😂😂

It goes Crazy for a name changed? Can’t it stick to THE ROOTS of info of that spreadsheet instead of THE NAME?
SPREADSHEETS names are meant to be changed. Is not like You are naming a Human Being.

Data / Edit Links
Nothing happens. Excel went crazy, you can’t handle excel this way.
you need to NEVER INTERCONECT TWO BOOKS ONE TO EACH OTHER, ALWAYS PUT ANOTHER ONE IN THE MIDDLE OF THIS.
This is the only way you can Data / edit links.


MY GOD.
 

Fireduptotwelve

New Member
Joined
Apr 19, 2020
Messages
9
Office Version
  1. 2019
Platform
  1. MacOS
Sorry, I didn’t checked mistakes and wrote fast from my tablet.
I D K how to edit once posted
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,122,530
Messages
5,596,699
Members
414,088
Latest member
rodriboraun

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top