Hello. If I set a date in one workbook and have that change in multiple workbooks (i.e. cells linked to that cell) Is that a good idea? I would actually prefer to change any cell (they are all linked to each other) and that would change all the others, but I'm not sure if that is a good idea. Thanks.
its a good idea , if you want to save typing in lots of different cells - or you could use a formula to refer to the sheet with the date on
just depends on what you are doing as to if a good idea
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
It's a good idea if all the functionality in the multiple workbooks really is dependent on that same single date. But consider for instance if the workbooks deal with say different years and you use that cell as the base date for say a series of months in a table. In that case it would be a bad idea.
For the links to update you will either need to open the master workbook, or use Data..Edit Links..Update Values
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks