Excel is not asking to save a changed file when the file is cl

MS EXCEL

Next

I have a excel spread sheet I use to track property I have purchased an sold. Due to how fast I buy and sell I need people in my office t have access to enter data on this spread sheet. I want my employees t be able to access this spread sheet but not be able to see all of th columns. I want them only to be able to enter and see the purchas information (Columns A thru J) but not be able to see or edit the sale information (Columns K thru N). What I would like is to have one sheet that more than one user coul use, but only let myself be able to see sales information (Cloumns thru N). It would be nice if everyone had there own password and onl my password would allow for all information to be visible. Could yo give me detailed instructions on how to make this happen. Let me tel you I am not an experienced Excel user, therefore will need ver detailed directions to follow
• 2. countif based on calculated field
I have a field that calculates a value from a range of fields: [BA2]=(AX2/49)/49*2*10 where [AX2]=SUM(A2:AW2) where A2:AW2 is a sorted list of numbers. Now, I want to count how many numbers in the list are below m calculated value BA2: [BC2]=COUNTIF(A2:AW2,"<BA2") The count however is 0, even though there are actually 4 numbers tha are below BA2 (whose value is 25.3). If I replace BA2 in the conditio with the value 25.3: [BC2]=COUNTIF(A2:AW2,"<25.3") it works. But it doesn't work if I leave it as BA2. I need to use this in 50 rows, and then I have to repeat for differen sets of data, so I can't keep typing in the value every time. Is ther any way to do what I am trying to do? (I'm using Excel 2002
Excel 2003 - I try to open some documents, and receive a error : "Excel cannot access '(file name).xls'. This document may be read-only or encrypted. I click on ok, and then it says "Cannot access '(file name).xls' The file is not read-only nor is it encrypted. I have tried reinstalling Excel with same results Any one have a solution
• 4. Challenge with Time Formatting - want to include AM or PM
Hi! Column A displays like this: 11:48:52. Column B displays AM. When I try to get column A to display with am or pm it converts the time to 12:00:00. I am not sure where the data is coming from, but it is being imported with this data as two seperate fields. Any suggestions?? Thanks!
• 5. Convert Excel file
hi, can we convert excel file to microsoft word format?

Re: Excel is not asking to save a changed file when the file is cl

```It happens 100% of the time.  I have tried a new file with the same results.
Subsequent to my positng I did see another thread where someone indicated
that what appeared to be the same problem was solved by removing an SAP
so I will be following that path to see if I can get a resolution to the
problem.  Thanks

```

```I need to save my spread sheet every 30 minutes to another file that I am not
working in, and this other file will not be saved over when I save to my
working file.
```

```I have a user that is using Outlook 2003, SP2.  He used to be able to drag a
file from a file server into an email message and was asked if he wanted to
create a hyperlink.  He is no longer being asked that, but would like to be.
Any ideas?

```

```When I close Excel (Office 2003) I am not prompted to save a file that has
been changed.  This was working; however, something has changed in the last
couple of months.  I thought there might be a setting somewhere, but I am
unable to see anything.
```

```Nick,

It was a GroupWise issue, but the fix was to press the reset button in the
Toolbar menu function. The worksheet menu bar was trying to access buttons
from the GroupWise addon, but it could not find them as it had been removed.

Resetting the menu bar basically erased those settings.

Thanks for your help, it did point me in the right direction.

"Nick Hodge" wrote:

> It is a Groupwise add-in that is added with that program. (It is an effort
> to integrate office into Groupwise, IMHO it failed!!)
>
> Can't remember the exact fix, but you should check on the Novell Website, it
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
>  XXXX@XXXXX.COM
>
>
> "lje" < XXXX@XXXXX.COM > wrote in message
> news: XXXX@XXXXX.COM ...
> > When I try to save any file in Excel, I receive a message that GWXL.xla
> > can
> > not be found. The only way I can save files is to exit the spreadsheet,
> > enter
> > the file name, than exit Excel. I have tried to create a file called
> > GWXL.xla, but that doesn't work either.
>
>
>
```

```When I exit a workbook I am not asked if I want too save the changes. How do
I fix that?
```