• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Database Help

G

guitarman

Member
I have a bit of a puzzle Why does'nt my database open up at the last place i inserted data it just opens up on row (112) every time and i am on row (2145). I realise it is not a big deal but it is so annoying that I have to scroll down every time.And the baffling thing is my other two(2) databases open up at the right place so why doesn't this one?

Many thanks

Mike
 
Guitarman


When you say Database, are you using Excel?

When I save a file and say my cursor is in H1000

When I re-open the file the cursor still shows me in H1000 even if I have closed the file in between
 
Hi Hui

Yes I am using Microsoft Excel 2010. I have tried leaving one cell highlighted but that does not work it seems no matter what I try it always opens at 112. I have even deleted the entries in those cell on 112 but even that does nothing bit of a Puzzler really.

Mike
 
Does the workbook have any macro's running that could cause that ?
 
or Is there a Viewing Pane or Freeze Pane defined which is causing the issue?
 
Hi Hui


Believe or not I have cured it don't ask me how I just deleted it all and reinstalled it onto the worksheet and low and behold it works perfectly I don't know why but something must have been amiss anyway problem solved thanks for your assistance in this matter have a great day and a brilliant life

Mike
 
You must log in or register to reply here.
Back
Top