PC Review


Reply
Thread Tools Rate Thread

Corrupt xlsm

 
 
AnandaSim
Guest
Posts: n/a
 
      5th Jul 2010
Hi All,

Working with some colleagues - they are reporting occassional Excel
messages saying "file corrupt" - the files may have started
as .xlsx, .xlt but they were delivered as .xlsm. After editing, by
someone else (various people), they display this message but not
uniformly. The cell data looks intact. The VBA is disabled. Excel has
been set to trust all macros.

Now, I found if I save the file as .xls, close and then re-open, the
VBA modules are now able to run - I used msgbox "hello world" as an
example.

It's not easy to figure out who/why is causing this corruption - do
you have any experience to share and/or tips?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
linking XLSM to XLS ado Microsoft Excel Setup 0 14th Apr 2010 07:16 PM
xlsm SaveAs xls Otto Moehrbach Microsoft Excel Programming 4 12th Dec 2009 06:39 PM
how can i convert .xlsm to xls vishu Microsoft Excel Misc 1 19th May 2008 03:16 PM
Saving up to xlsm Deb Microsoft Excel Misc 1 25th Apr 2008 01:46 AM
xlsm WhytheQ Microsoft Excel Programming 2 18th Feb 2008 12:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:47 PM.