I have a map in arcmap where i want to display information that contains values that will probably change every year. I would rather not having to remove joins and then join my new excel sheet every year. Is there a way:
- To directly link my excel sheet to asrcmap so that my map would be modified upon the excel modification
- As my excel numbers would change based on a multiplication factor, is there a way to save the formula in the attribute table so that my values would automatically change when i input the new multiplication factor into arcmap?