updating infomation

thuy4657

New Member
Joined
Dec 23, 2005
Messages
5
is there a way to update information in a spreasheet without the update screen poping up for only 1 particular spreadsheet? I know you can adjust the global excel options to auto update without asking but can i specifically do this for only one spreadsheet/excel file?
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

sweater_vests_rock

Well-known Member
Joined
Oct 8, 2004
Messages
1,657
thuy.

i may be oversimplifying, but could you just check the workbook/worksheet name before you disable to update box? that way, if you are updating any other workbook/worksheet but the one you have designated, you will get the message.

just a thought. ben.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,697
Members
412,481
Latest member
nhantam
Top