Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel 2000 - Printing Problem


  • Please log in to reply

#1
vetless

vetless

    New Member

  • Member
  • Pip
  • 3 posts
I'm not sure but I think the problem might stem from the fact that I emailed to file from office to my home computer. After I while I noticed that after the file name, the word 'Group' appeared within brackets, like the following: [Group]. I cannot set a print area, or print from this file. Does anyone know what's going on? Can you help?
vetless
  • 0

Advertisements


#2
boomercj

boomercj

    Member

  • Member
  • PipPipPip
  • 122 posts
Perhaps you had more multiple sheets within the workbook selected. Excel refers to that as a group. That happens if you click on one tab while holding the shift key and then click on a tab one or more sheets later. You will notice that those two tabs along with all of the tabs between are highlighted/selected. You may have just emailed the group rather than the entire workbook.

Don't know if this helps, but I hope this sheds a little light on the subject.
  • 0

#3
vetless

vetless

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
Thanks for your reply. Do you have any idea how I can get this resolved? I've even tried copying the data to a new file, but as soon I try to save it after copying it, the same thing happens. Do you have a remedy?
vetless
  • 0

#4
boomercj

boomercj

    Member

  • Member
  • PipPipPip
  • 122 posts
just a quick off the top of my head thing.........

if you can, in the workbook, click on a tab that is not included in the group. This should remove the group. Then you can email the whole workbook. Right now, I'm experimenting with grouped worksheets to see if there is another solution. Can't make any promises. Dr. Frankenstein experimented and we all know how that ended up!
  • 0

#5
boomercj

boomercj

    Member

  • Member
  • PipPipPip
  • 122 posts
Duh. Sometimes I can be so silly........

Right click on one of the tabs in the group. Click Ungroup.
  • 0

#6
vetless

vetless

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
Oh, thank you boomercj I just tried it on a file that I had here at home, and it worked!!! It should work on the latest file I have at the office. Once again, thank you, thank you, thank you!!! You are brilliant!!!!!!!

vetless
  • 0

#7
boomercj

boomercj

    Member

  • Member
  • PipPipPip
  • 122 posts

You are brilliant


Thank you so much. I think I will cross stitch this into a sampler and hang it so my family sees it everyday!
Glad I could help.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP