Hi, I'm having problems with this excel file. I'm guessing after troubleshooting it, it's the file size but I just want to see if there are something I miss.

Error Message when saving to the network.
Disk if Full

What I did.
1. Save as a different file - error sometimes
2. Installed new network cables (cat 6)- error sometimes
3. Switch network cable to a different port on the main switch (same problem)
4. Installed a brand new bought computer and same problem.
5. Tried saving off from a high end laptop but same problem.

The file is 3 MB.

Sometimes it save and sometimes I get the error.

Please help

A 3MB file size really shouldn't be a problem, at least not as the direct cause.

A couple of things to keep in mind and to try:

When Excel opens a file, it puts a temp copy of the same file (same size) in the same directory. It doesn't delete this temp file until a save of the original is complete. Therefore, in order to save the file, you have to have twice as much disk space as the actual file size.

I assume you've checked the available disk space and it's well abouve the 6 MB required, right?

Have you tried saving it locally to see if the problem still occurs? That would confirm or eliminate the network as the issue.

Google the problem - it appears to be a fairly common issue, but not one with a single, concrete solution. maybe something you'll read will point you towards a solution.

Try this article for other suggestions.

http://support.microsoft.com/defaul...

Finally, as a work around, you might try some VBA to save it locally (assuming that you can) and then copying the file to the network drive. I'm pretty sure this could be done with a Before_Save macro stored inside the workbook. That would make it fairly transparent to the user.

Good luck!

K, I fix the issue.
Within the nic properties... i change the settings from auto detect to full dulex...

Hope this helps anyone who had this similiar prob.

Thanks for your help derby