Excel Saving

[turps]

Hi

Does anyone know why when I save my excel file it goes through the process of saving twice?

Any help?

Thanks


Regards

David

 

[dcompto]

Look at your Save As dialog. Is it set to a dual document type (e.g., Microsoft Excel 5.0/7.0)? If so, change it to the normal Microsoft Excel Workbook (*.xls) document type.

 

[turps]

Hi

Thanks for your posting. I have had a look and it is aready set to Excel Workbook.

Any other ideas?



Regards

David

 

[xlbo]

do you have any code in the workbook?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[turps]

I have a lot of vba code within the document. I thought that this might be the problem. Saying that I have a number of spreasheets that also contain code but none of these have the problem saving.



Regards

David

 

[xlbo]

certain events can be triggered by save action - without knowing what code you have, it could be anything - tends to happen with calculating or sheet activate / de-activate most commonly however...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[turps]

Thank you Geoff for your answer. I have used sheet activate code to select the current months sheet.



Regards

David