Can't save freeze panes

[doncole]

How do I save freeze panes with Excel 2010?

I know how to freeze the panes but they don't save.

Any help appreciated.

Don Cole

[NeedForExcel]

You do not have to do anything special to save it..

Just freeze panes, and save the workbook.

[FDibbins]

The panes should stay the way they are when you save them - are you saying that this is not the case?

[doncole]

Yes, this this is the case.

Every time save and reload the freeze panes re gone.

Don Cole

[doncole]

[QUOTE=FDibbins;4376647]The panes should stay the way they are when you save them .
They don't.
What do you me by VBA tags?

[NeedForExcel]

What do you me by VBA tags?

You have to wrap your code around VBA Tags if you are posting any code.. In your case you aren't. So worry not..

[doncole]

You do not have to do anything special to save it..

Just freeze panes, and save the workbook.

Not true the freeze panes do not save.

Don Cole

[NeedForExcel]

They do..

See the file attached. I have saved it after freezing panes..

[FDibbins]

[QUOTE=doncole;4378192]

What do you me by VBA tags?

That is part of my signature, for those posting VBA code

[FDibbins]

Not true the freeze panes do not save.

Don Cole

Yes, they do. If yours are not saving, then there is another problem

[Larena]

When I open it, I can see that some rows and columns are frozen so this is likely to be an issue on your PC.

Is this a shared spreadsheet? If so, try un-sharing it & see if anything changes. I recently had an issue where multiple people were sharing a spreadsheet (against my advice), and although freezing worked for some people for others all visible rows and cells were frozen and they couldn't scroll to any other cells.

[NeedForExcel]

I dont think Sharing has anything to do with freeze panes.. If you could attach your file that has the issue, maybe we can comment better..

[Larena]

I dont think Sharing has anything to do with freeze panes.. If you could attach your file that has the issue, maybe we can comment better..

The problem I described is one of the many bugs with sharing, and there were many hits when I Googled the issue at the time.

[doncole]

They do..

See the file attached. I have saved it after freezing panes..

Thank you for uploading that file.

when I down loaded the file it held the freeze panes.

Strange thing,

I even changed the freeze pane setting on your file and saved it.

That works.

But When I try save the freeze panes on one of my files it doesn't save the freeze panes. It saves changes in the data ok.

If I could figure out how to transfer my data to your file it should work fine.

Don Cole

[FDibbins]

can you upload your file here? cleaned of any sensitive data, of course

[doncole]

I dont think Sharing has anything to do with freeze panes.. If you could attach your file that has the issue, maybe we can comment better..

How do I do that on this forum?

Don Cole

[doncole]

can you upload your file here? cleaned of any sensitive data, of course

How do I do that?

[doncole]

can you upload your file here? cleaned of any sensitive data, of course

How do I do this?

Don Cole

[protonLeah]

(How to) Upload a Workbook directly to the Forum

• In the upper left pane "upload files from your computer" click the choose button and navigate to your file.
• Select the file, click "OPEN"
• Click upload in the upper right pane
• When the file is uploaded, close the file manager tab.
• Click submit.

[NeedForExcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

[doncole]

can you upload your file here? cleaned of any sensitive data, of course

Here's the offending file.

Don Cole

[protonLeah]

When I tried to open your file, I got an error message: Invalid Extension. I had to change it from .xlsx to .xls (in Windows explorer) to open it
I froze rows 1/2 and saved as .xlsx & reopened - ok.

[FDibbins]

I got an error too - File Format or Extension is not valid