I have a client using Excel 2007. In 2003, he use to get a pop up created by
a macro- that says do you want to update all of the fields in the
spreadsheet. He's collecting data from multiple locations and the macro
brings back data and fills the data. 2007 does not give him the option to do
that. He can make an individual field but there are multiple fields.
Selecting all fields will not work.

I suggested he update the macro but was told he would have to do each
individual field. Any suggestions.