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.

hi
some users have reported that some things did change between 03 and 07 but
the information you provided is not enought to make a suggestion except post
the code.

regards
FSt1

"G" wrote:

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.