here is something odd

[Richard Schollar]

Yes - how did you know that?

 

[RoryA]

Might just be coincidence, but I ahve read that Excel can try to use the root of the MyDocuments drive to create temp file when copying sheets. If you don't have access rights to the root (as is often the case with a network location), it fails with an error like the one you described. Of course it may also simply be a sign of corruption. If it's just one sheet having the issue, try copying all the cells to a newly inserted one and see if that fixes it. If so, it's probably worth thinking about creating a new copy of the workbook!

 

[Richard Schollar]

Thanks Rory - copying the cells to a newly added sheet removed the problem. I am going to recreate the wb I think (it's a horrible wb in any case - one that I didn't set up I might add ).

I am astounded once again by your Excel knowledge - you are an Excel God among men!

that should be enough fawning for at least the first two pints on you on Thursday!

 

[RoryA]

Unfortunately, my aged eyesight cannot clearly make out what I assume to be words in some horrible green font at the bottom of your last post. Perhaps you can elaborate as you get the first round in on Thursday?

 

[riaz]

or perhaps even

=Round("Schollar",2)

 

[RoryA]

In XLM:
=GET.BAR(2,"Order",2)

 

[Cbrine]

Here's an odd one, I've only encountered for the first time today.

1. Take a few cells and merge them.
2. Create an array formula and press the ctrl-shift-enter

This gives me a "Array formulaas are not valid in merged cells" error.

Now.
1. Create an array formula in a cell.
2. Highlight the formula cell, and a few others and press the merge button.

WHAT????I thought arrary formulas were not allowed in merged cells

Cal

 

[RoryA]

They're not, but clearly merged cells are allowed in array formulas. Of course if you try and edit it, then you're putting an array formula in a merged cell...