Fireduptotwelve
New Member
- Joined
- Apr 19, 2020
- Messages
- 9
- Office Version
- 2019
- Platform
- 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.
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.