SarahC Posted September 11, 2007 Share Posted September 11, 2007 Hi there,I have an excel spreadsheet which is only 117kb's in size. It's a template file and when I go to remove some of the comments in it, it freezes and I have to end task to get out of it. It doesn't happen with all the comments, just some of them?? Any help is much appreciated as at the moment I can't change it as I need to!Sarah Link to comment Share on other sites More sharing options...
tain Posted September 12, 2007 Share Posted September 12, 2007 While the document is open, hit Alt-F11 and look in there to see if there is any VBA code. If there is, and you don't need it: delete it. Then save a BACKUP COPY of this document and open it back up.There is a picture of the screen about halfway down this page: http://pubs.logicalexpressions.com/pub0009...icle.asp?ID=302 Link to comment Share on other sites More sharing options...
SarahC Posted September 21, 2007 Author Share Posted September 21, 2007 Hi TAiN,Thank you for your reply! However, there is no VBA code associated with this excel file??!Sarah Link to comment Share on other sites More sharing options...
tain Posted September 21, 2007 Share Posted September 21, 2007 You might try creating a new spreadsheet and copy/pasting just the data you want into the new sheet. Even if it takes a couple of copy/paste operations, it'll be worth it to not be haunted by whatever is wrong with that particular spreadsheet.You could also try saving it as an older file format. That shouldn't compromise any data unless you use new features (unlikely). Link to comment Share on other sites More sharing options...
SarahC Posted October 24, 2007 Author Share Posted October 24, 2007 Cheers Tain, I had already copied and pasted some of the data to try it and it seems to work!! I will try saving it as an older file format though as you suggest, it maybe the best solution.Thanks for your time!Sarah Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now