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



  • 1. share workbook and limit access to users
    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
  • 3. Error on loading worksheets
    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

Postby Um9u » Tue, 15 Mar 2005 10:05:02 GMT

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 
Business ONE Office Integration Add-On.  I have this same Add-On installed, 
so I will be following that path to see if I can get a resolution to the 
problem.  Thanks

Similar Threads:

1.Can I auto save to a separate file?(not the file I am working in)

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.

2.I am not being asked "Create a hyperlink here" when I drag files i

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?

Thanks for your help!

3.Excel is not asking to save a changed file when the file is closed

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.

4.When saving any file in Excel, I am aked for a file that can n


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 
> had something to do with removing integration and the add-in
> -- 
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> "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. 

5.Upon exiting Excel I am not prompted to SAVE the file

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

6. File close excel does not ask me to save changes

7. Am i the first person to close and excel file, without saving chan

8. why am I unable to save a Excel file on a network drive%3f

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 70 guest