How to maintain adjusted row/column positions

[newbiejb]

I'm having a recurring problem of having the adjusted individual row height or individual column width return to their previous positions before adjustment. What method do I use to have the rows/columns maintain the new adjusted position?

[6StringJazzer]

When you change column width or row height it should never change back.

Under what conditions do you see it change back? Is there any action you take that triggers it to change back, like closing and reopening the file?

Are you running any macros in that workbook?

Is it just one workbook, or all of the ones that you work with?

[newbiejb]

This morning I opened up the worksheet and all the adjusted columns and rows had returned to their former positions. Here's the thing: I imported an Access database to Excel about a month ago, that's what I'm working with now. I wonder if some sort of default is controlling things here. The rows all seem to be of uniform height size which they shouldn't be. Same with the columns, one day they get adjusted, the next day they are all back where they originally were. There's 3,000 rows in this spreadsheet and in seven days I need to finalize it for publication. What protocol command needs to be addressed? Thanks.

[6StringJazzer]

How did you do the import? If you have some kind of link, maybe it's refreshing the data from the database every time you open it and that wipes out your formatting.

[newbiejb]

Yes, I utilized the "Office Links" in Access and "Analyze It With MS Office Excel" command to send it to Excel. I can enter and delete data but the row and columns do not stay put when re-sized.

[6StringJazzer]

I am pretty sure that Access is wiping out your formatting. I do not know any way to prevent it, and have not done this with Access so there may be some alternatives that I'm not aware of.

One workaround is to create a worksheet with all the formatting you want, then import the refreshed data into another worksheet (or even a worksheet in a different file). The formatted worksheet can have formulas that just directly refer to the corresponding cells in the worksheet with the live data.

Another option is to set up the formatted worksheet, then do a copy of the live data and Paste Special, Values into the formatted worksheet.