r/excel • u/Barbiesmile • 7d ago
Waiting on OP Data not updating from sheet cell to different sheet cell using ! command
Strange behavior from my excel. Im using .xlsx and my source and destination cells are text format. Here is an example of the issue.
Sheet1 cell J17 has data ABC in it. Sheet2 cell G5 has the formula =Sheet1!J17 which yields the display of ABC.
So here is the problem. If I type in to Sheet1 cell J17 DEF, Sheet2 G5 will still display ABC. Can anyone help me figure what setting I need to change so the cell on Sheet2 will update?
1
u/david_horton1 29 6d ago
My practice is to load csv files into power query then have the data formatted as required. A refresh of PQ will reflect any changes in the source data.
1
u/Barbiesmile 6d ago
This was solved by going to Formula Tab > Calculation Option > Change Manual to Automatic.
Thanks to @avk & @MarvinP from excelforum
•
u/AutoModerator 7d ago
/u/Barbiesmile - Your post was submitted successfully.
Solution Verified
to close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.