How to update an excel formula to accept new data source

September 29, 2016 at 07:42:48
Specs: Windows 64
Hi, I have an excel workbook that has a formula that is no longer working because it is saying it cant find the data source. I have would like to know how I can change the formula to look for a new data source in all workbooks?

See More: How to update an excel formula to accept new data source

Reply ↓  Report •


#1
September 29, 2016 at 11:32:19
I'm not sure what you mean by "look for a new data source in all workbooks".

What happened to the original data source?

I think we need some more details.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •

#2
October 6, 2016 at 08:26:12
I changed computers. The excel i was working in is 97-2003 i moved to windows 10. I work in compatibility mode but when I open most files that pull data based on formulas it says that it cant find my data source. but I have some 3 files that I can find and update my data source

Reply ↓  Report •

Related Solutions


Ask Question