changes across all worksheets

seharris · Feb 24th, 2002, 04:37 PM

Some how i changed the settings in a notebook and now when i enter data in one worksheet, the same data is entered in all the other worksheets. How did i do this? How can I get rid of it?

Aladin Akyurek · Feb 24th, 2002, 04:46 PM

Quote:

On 2002-02-24 15:37, seharris wrote:
Some how i changed the settings in a notebook and now when i enter data in one worksheet, the same data is entered in all the other worksheets. How did i do this? How can I get rid of it?

You probably grouped all the worksheets of your workbook. Give a right click on a tab of a worksheet to see whether they are grouped. if so, ungroup them.

Just a thought.

seharris · Feb 24th, 2002, 05:00 PM

i tried right clicking on the sheet tabs, but nothing about grouped worksheets is there. any other advice?

anno · Feb 24th, 2002, 05:24 PM

maybe a silly question, but did you actually click on the sheet name itself (ie not on the sheet somewhere)? are all the sheet tabs white or is just one white and the others grey? if they are all white it should mean that the sheets are grouped, and by right clicking on the sheet tab you'll get a shortcut menu, the top item of which will be 'ungroup sheets'. if you don't get this on the menu it probably means your sheets aren't grouped but if that's the case,beyond sheet corruption or some vba code (you can see this by right clicking on the sheet tab and selecting 'view code' from the shortcut menu) which is making it behave this way i can't see why this is happening.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 24th, 2002, 04:37 PM	#1
seharris New Member Join Date: Feb 2002 Posts: 2	Some how i changed the settings in a notebook and now when i enter data in one worksheet, the same data is entered in all the other worksheets. How did i do this? How can I get rid of it?

Feb 24th, 2002, 05:00 PM	#3
seharris New Member Join Date: Feb 2002 Posts: 2	i tried right clicking on the sheet tabs, but nothing about grouped worksheets is there. any other advice?

Feb 24th, 2002, 05:24 PM	#4
anno Board Regular Join Date: Feb 2002 Posts: 202	maybe a silly question, but did you actually click on the sheet name itself (ie not on the sheet somewhere)? are all the sheet tabs white or is just one white and the others grey? if they are all white it should mean that the sheets are grouped, and by right clicking on the sheet tab you'll get a shortcut menu, the top item of which will be 'ungroup sheets'. if you don't get this on the menu it probably means your sheets aren't grouped but if that's the case,beyond sheet corruption or some vba code (you can see this by right clicking on the sheet tab and selecting 'view code' from the shortcut menu) which is making it behave this way i can't see why this is happening.