Tricky88 Posted April 24, 2007 Report Share Posted April 24, 2007 ive got excel 2003 which has been working fine but i tried to do meeting info tonite and i can open up the files and view them ok but it wont let me change anything view only so i cant change drivers numbers to calculate grids and also i cant update the league standings ? ..... any ideas Link to comment Share on other sites More sharing options...
MoR137 Posted April 24, 2007 Report Share Posted April 24, 2007 ive got excel 2003 which has been working fine but i tried to do meeting info tonite and i can open up the files and view them ok but it wont let me change anything view only so i cant change drivers numbers to calculate grids and also i cant update the league standings ? ..... any ideas I'm not 100% sure, but it might be set to 'Read-Only' Try finding an excel file you want to open, right click it and choose properties and check that the Read-only box isn't ticked? Might work, but like I say, i'm not 100% sure. Link to comment Share on other sites More sharing options...
Tricky88 Posted April 25, 2007 Author Report Share Posted April 25, 2007 thanks m8 just checked that and no its not ticked so cant be that Link to comment Share on other sites More sharing options...
reg126 Posted April 25, 2007 Report Share Posted April 25, 2007 Another possiblity is that its been saved in the wrong format so will not allow changes in which case you will have to backtrack. Link to comment Share on other sites More sharing options...
DanSkin Posted April 25, 2007 Report Share Posted April 25, 2007 Could it be that somehow the settings have changed and the sheets have become protected (can lead to not being able to change data, etc.. Try... Tools > Protection > Unprotect sheet (it does it by sheet alone, not the whole collection of them) If unprotect sheet isnt an option there then this isn't the problem Link to comment Share on other sites More sharing options...
wrighty496 Posted April 25, 2007 Report Share Posted April 25, 2007 Could it be that somehow the settings have changed and the sheets have become protected (can lead to not being able to change data, etc.. Try... Tools > Protection > Unprotect sheet (it does it by sheet alone, not the whole collection of them) If unprotect sheet isnt an option there then this isn't the problem Also, if the sheet has macros for calculating things, make sure macros are enabled when you open the spreadsheet m8 Link to comment Share on other sites More sharing options...
Adam Posted April 25, 2007 Report Share Posted April 25, 2007 If that doesnt work, maybe upload it up to here and ill have a look if it works on mine. Link to comment Share on other sites More sharing options...
Tricky88 Posted April 25, 2007 Author Report Share Posted April 25, 2007 Could it be that somehow the settings have changed and the sheets have become protected (can lead to not being able to change data, etc.. Try... Tools > Protection > Unprotect sheet (it does it by sheet alone, not the whole collection of them) If unprotect sheet isnt an option there then this isn't the problem most of the options at the top are shaded so i cant use them tools protection is there but the rest is shaded Link to comment Share on other sites More sharing options...
Tricky88 Posted April 25, 2007 Author Report Share Posted April 25, 2007 here is one of the sheets NEW_NHR_MItmp.zip Link to comment Share on other sites More sharing options...
Adam Posted April 25, 2007 Report Share Posted April 25, 2007 Seems to work fine here mate. Have you tryed re installing Excel? Link to comment Share on other sites More sharing options...
Tricky88 Posted April 25, 2007 Author Report Share Posted April 25, 2007 Seems to work fine here mate. Have you tryed re installing Excel? yes m8 i give up with bloody computers Link to comment Share on other sites More sharing options...
Adam Posted April 25, 2007 Report Share Posted April 25, 2007 Seems to work fine here mate. Have you tryed re installing Excel? yes m8 i give up with bloody computers lol sorry i couldnt help more Link to comment Share on other sites More sharing options...
Tricky88 Posted April 25, 2007 Author Report Share Posted April 25, 2007 Seems to work fine here mate. Have you tryed re installing Excel? yes m8 i give up with bloody computers lol sorry i couldnt help more np m8 what with excell bt probs then the stock rod forum going down im off to take up tiddley winks knowing my luck my tiddley would end up under the wardrobe Link to comment Share on other sites More sharing options...
Tricky88 Posted April 30, 2007 Author Report Share Posted April 30, 2007 i had a message come up saying security was to high so the macros wouldnt open but when i try to change the macros half of the options come up shaded .... this happens on all the top options ? Link to comment Share on other sites More sharing options...
wrighty496 Posted May 1, 2007 Report Share Posted May 1, 2007 i had a message come up saying security was to high so the macros wouldnt open but when i try to change the macros half of the options come up shaded .... this happens on all the top options ? what OS u using? sounds like inbuilt security is blocking the macros m8 (well maybe OS, maybe AV) - re: the greyed-out options, are they all the same with a sheet with data in? (you might get less options showing because you've got a blank sheet open) Link to comment Share on other sites More sharing options...
Tricky88 Posted May 1, 2007 Author Report Share Posted May 1, 2007 happens exactly the same with a sheet up there m8 just stopped working overnite Link to comment Share on other sites More sharing options...
Tricky88 Posted May 2, 2007 Author Report Share Posted May 2, 2007 i use antivir guard for security m8 Link to comment Share on other sites More sharing options...
Recommended Posts