Computer Help forum

Question

problem with closing an excel file.

by vizvizoo / November 4, 2015 2:31 AM PST

Hi everyone,
I'm working as an IT Support in a company.
I've got some excel files which when I try to close them, they hang and whole the excel sheet page turns into black color and I've to close the program from task manager. This problem only happens in some of computers I've already tried with, not all!

Also there's an exclamation mark on each excel icon. Are these marks because of too many Macros on each file?
What can be the problem of closing?..

Any help would be appreciated.
Sarah

Discussion is locked
You are posting a reply to: problem with closing an excel file.
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: problem with closing an excel file.
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.

All Answers

Collapse -
Answer
Re: Excel
by Kees_B Forum moderator / November 4, 2015 2:53 AM PST

That's strange indeed.

Probably it won't help to get a solution, but some more info would be nice. Such as:
- What OS?
- What version of Excel are you running?
- What file extension (xlsx can't contain macro's, xls and xslm and xslb can)?
- Where is that Excel icon that has that exclamation mark? In Windows Explorer?
- What happens if you click that exclamation mark? Sometimes that gives an explanation.
- Where do you 'have' those files? Local hard disk, network share, Sharepoint, OneDrive, USB-stick?
- Does 'Save As' to new file of same filetype work?
- Does 'Save As' to new file of other filetype work?
- What is different between the computers where it works and the computers where it won't work?

It makes sense to answer questions like this before you call Microsoft support. And maybe it leads to a solution without even calling them.

Kees

Collapse -
Oh sorry I didn't explain everything :)
by vizvizoo / November 4, 2015 3:27 AM PST
In reply to: Re: Excel

Well the OS is 7 on each computer and all are using MS 2010. So there's no differences between the computers.
File type is "xlsm". I read somewhere if I change the file type to "xlsx" the exclamation mark will be gone, it happened when i changed! but the files were not working anymore!
also nothing actually happens when I click on the exclamation marks! and there's even no explanation Happy
The files were in a DVD and I copied them on share folder on our server and also on my hard drive. the files work perfectly on my own computer, the only thing is Macros are not working on the share folder. but that's not the problem! they work file on my hard drive!

Collapse -
Re: macro's not working from share
by Kees_B Forum moderator / November 4, 2015 6:33 AM PST

That seems to be the default setting. But you can use the Trust Center to tell Excel to trust that share enough to execute macro's from it.
Don't you love that security?

Kees

Collapse -
Answer
A few thoughts on Excel Problems
by ReturnBackupDotcom / November 4, 2015 3:13 AM PST

Sometimes, Excel will hang due to a bad printer installation. I know this sounds strange, but Excel looks for the default printer driver before saving or closing a workbook. If there is a bad printer installation, an error can occur. To resolve this you will have to uninstall and reinstall the printer.

A. Find the printer: On the Control Panel go to Programs and Features. Most printers should be listed here. If it is (listed that is), right click on it and left click on "Uninstall". If the printer isn’t listed, go to the Windows START button and click "Devices and Printers". Find ‘Printers and Faxes’ and right click on the applicable printer and then left click on "Uninstall".

B. Right click on the printer and left click 'Remove Device'. This will uninstall the printer.

C. Reinstall the printer.

This may fix it.

As far as the exclamation point, this is typical of excel files with Macros. If you trust the document and you created the Macros, it should be fine.

Collapse -
well..
by vizvizoo / November 4, 2015 3:49 AM PST

well.. i'm not sure if this is the problem! cause 3 of the computers don't have any printers and they hang at closing the files.

this is how it hangs..
http://i.share.pho.to/8506ba5c_o.png

Collapse -
Re: printer
by Kees_B Forum moderator / November 4, 2015 4:01 AM PST
In reply to: well..

Then define a printer on those PC's and make it the standard printer. Does that help?

Kees

Collapse -
didn't work
by vizvizoo / November 4, 2015 4:26 AM PST
In reply to: Re: printer

this also didn't work Happy

Collapse -
There's a clue in that read only.
by R. Proffitt Forum moderator / November 4, 2015 6:20 AM PST
In reply to: well..

Why is it read only? And maybe Excel does hang like this on read only files. I don't see all the details yet but could be what Excel does for version of OS and Excel?

"The files were in a DVD" is your clue. Those would be RO and you need to remove that.

Not much new here. But a lot of new IT staffers struggle with file attributes.

Collapse -
.
by vizvizoo / November 6, 2015 9:37 PM PST

well it doesn't matter if it's read only or no.
i just tried to take a fast screen shot, but i also tried to open in in read only mode and also not as read only! both result were same at closing it, it hanged on user computer but mine!
well i try to work more on it!.. i think the problem comes somewhere from the macros, but i don't know how to solve it! Happy

Collapse -
Be sure to check the old Excel Safe Mode method.
by R. Proffitt Forum moderator / November 6, 2015 10:46 PM PST
In reply to: .

If that doesn't pan out check the event viewer.

Collapse -
Safe Mode didn't work
by vizvizoo / November 6, 2015 11:43 PM PST

I tried with safe mode, it didn't work too.
and I'm not sure where in even viewer should i exactly check.. would you please tell me more details? Happy

Collapse -
Sorry no.
by R. Proffitt Forum moderator / November 7, 2015 8:05 AM PST
In reply to: Safe Mode didn't work

For me I clear the Event Viewer, crash and then look at the results for clues. There have been many fine clues to this point the best being the copy from DVD which should result in odd read only file save problems.

This is pretty basic IT stuff yet I find IT (most new ones) that are not into Windows. That is, the Event Viewer should not be foreign to support staff. Yet it can be.

Maybe it's time to call in Microsoft?

Collapse -
haha thanks!
by vizvizoo / November 7, 2015 8:33 PM PST
In reply to: Sorry no.

Actually it's just one month I'm officially having job experience! I think everyone must have an start someday somewhere!
but thank you I'm working on it Happy and try to find out more about Even Viewer,
and if it didn't work, I'll call Microsoft Happy

Thanks everyone for helping me and giving me ideas to the way of solving my problem.

Popular Forums
icon
Computer Newbies 10,686 discussions
icon
Computer Help 54,365 discussions
icon
Laptops 21,181 discussions
icon
Networking & Wireless 16,313 discussions
icon
Phones 17,137 discussions
icon
Security 31,287 discussions
icon
TVs & Home Theaters 22,101 discussions
icon
Windows 7 8,164 discussions
icon
Windows 10 2,657 discussions

Does BMW or Volvo do it best?

Pint-size luxury and funky style

Shopping for a new car this weekend? See how the BMW X2 stacks up against the Volvo XC40 in our side-by-side comparison.