|
Prompt to save on closing
Hi,
When I open an Excel file and close it, without making any changes, it always prompts to save. There are no links in the file and no code either; nothing I can find that causes this. Any ideas? Thanks, Jake |
Maybe you have Volatile functions like
AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Hi, When I open an Excel file and close it, without making any changes, it always prompts to save. There are no links in the file and no code either; nothing I can find that causes this. Any ideas? Thanks, Jake |
Thanks Ron, I hadn't thought of that, but unfortunately my file doesn't
contain any of those functions. Jake "Ron de Bruin" wrote in message ... Maybe you have Volatile functions like AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Hi, When I open an Excel file and close it, without making any changes, it always prompts to save. There are no links in the file and no code either; nothing I can find that causes this. Any ideas? Thanks, Jake |
Maybe
Dave Peterson posted this : Excel likes to recalculate workbooks created in earlier versions. Is this the case in your situation? -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message ... Thanks Ron, I hadn't thought of that, but unfortunately my file doesn't contain any of those functions. Jake "Ron de Bruin" wrote in message ... Maybe you have Volatile functions like AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Hi, When I open an Excel file and close it, without making any changes, it always prompts to save. There are no links in the file and no code either; nothing I can find that causes this. Any ideas? Thanks, Jake |
Thanks again Ron, this doesn't seem to be the problem either. Thanks for
the help though Jake "Ron de Bruin" wrote in message ... Maybe Dave Peterson posted this : Excel likes to recalculate workbooks created in earlier versions. Is this the case in your situation? -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message ... Thanks Ron, I hadn't thought of that, but unfortunately my file doesn't contain any of those functions. Jake "Ron de Bruin" wrote in message ... Maybe you have Volatile functions like AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Hi, When I open an Excel file and close it, without making any changes, it always prompts to save. There are no links in the file and no code either; nothing I can find that causes this. Any ideas? Thanks, Jake |
Hi Jake
If you want you can send me the workbook (private) I will look at it for you then -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Thanks again Ron, this doesn't seem to be the problem either. Thanks for the help though Jake "Ron de Bruin" wrote in message ... Maybe Dave Peterson posted this : Excel likes to recalculate workbooks created in earlier versions. Is this the case in your situation? -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message ... Thanks Ron, I hadn't thought of that, but unfortunately my file doesn't contain any of those functions. Jake "Ron de Bruin" wrote in message ... Maybe you have Volatile functions like AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Hi, When I open an Excel file and close it, without making any changes, it always prompts to save. There are no links in the file and no code either; nothing I can find that causes this. Any ideas? Thanks, Jake |
Hi all
There are comboboxes on the sheet with a linkedcell and a listfillrange. That is the reason why it always prompts to save. -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Jake If you want you can send me the workbook (private) I will look at it for you then -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Thanks again Ron, this doesn't seem to be the problem either. Thanks for the help though Jake "Ron de Bruin" wrote in message ... Maybe Dave Peterson posted this : Excel likes to recalculate workbooks created in earlier versions. Is this the case in your situation? -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message ... Thanks Ron, I hadn't thought of that, but unfortunately my file doesn't contain any of those functions. Jake "Ron de Bruin" wrote in message ... Maybe you have Volatile functions like AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Hi, When I open an Excel file and close it, without making any changes, it always prompts to save. There are no links in the file and no code either; nothing I can find that causes this. Any ideas? Thanks, Jake |
Thanks for posting back with the solution--or at least the cause <bg.
Ron de Bruin wrote: Hi all There are comboboxes on the sheet with a linkedcell and a listfillrange. That is the reason why it always prompts to save. -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Jake If you want you can send me the workbook (private) I will look at it for you then -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Thanks again Ron, this doesn't seem to be the problem either. Thanks for the help though Jake "Ron de Bruin" wrote in message ... Maybe Dave Peterson posted this : Excel likes to recalculate workbooks created in earlier versions. Is this the case in your situation? -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message ... Thanks Ron, I hadn't thought of that, but unfortunately my file doesn't contain any of those functions. Jake "Ron de Bruin" wrote in message ... Maybe you have Volatile functions like AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() -- Regards Ron de Bruin http://www.rondebruin.nl "Jake" wrote in message .. . Hi, When I open an Excel file and close it, without making any changes, it always prompts to save. There are no links in the file and no code either; nothing I can find that causes this. Any ideas? Thanks, Jake -- Dave Peterson |
| All times are GMT +1. The time now is 10:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com