View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick M Rick M is offline
external usenet poster
 
Posts: 3
Default Worksheets -locked out of my own workbook.

I have a large workbook I use to record purchase orders in, for what its
worth the workbook was started on a Windows 95 Office 97 computer, as the
years have gone by different computers,users have been adding info and making
changes.
There are 4 sheets. I am trying to divide this year into quarters by making
another sheet.
When I try to do this, the "copy sheet" or "move sheet" info is shown in
gray, rather than bold type so I am unable to use these drop downs and click
on what I am trying to do. From what I can tell , the workbook is not
password protected, I am baffled a bit.
I don't have a network, I work in the day on a desktop, then copy this file
to a "memory stick" and some nights take home to work on my laptop. I then
resave the whole notebook. I am trying to get where I just can use the
current year instead of every time I save or add to it, I copy all 4 sheets.

Ideally, I would like to just have one sheet per year, and be able to break
that down to semi-annual or quarters, just so when I take the work home I
don't have to copy the whole database just to work with a few rows.
--
Rick M