Database Info

Excel problem

I have an excel file I use for inventory, it's about 2.3mb in size. I opened the file, did inventory (which has lots of formulas to calculate different things), saved the file - it took FOREVER! Found out why - it became 19MB!!!!
I've been using a very similar file (same formulas) for several years, never had this happen. When I copied it to the PC and opened/saved in Excel 2002, it reverted to 2.4mb.
Separate annoyance, happens often, enter data into ANY excel file and if I've opened it on my PC previously, when I save the file on the PPC it says "Incompatible information" and prompts me to save it as a different file name. I simply write over the old name and never have any problems but IT'S FREAKING ANNOYING! Any thoughts?
AT&T Tilt running Dutty's WM6.1
on the PC - WinXP sp2, Excel 2002 SP3...

grr, nevermind, I forgot all the things pocket excel doesn't support - like MEDIAN... still don't know why that would cause it to balloon to 19mb, but...

Hi, having some problems with my Touch Pro

Please bear with me, as this is my first windows mobile phone and I'm not all too familiar with it.
First problem is, tapping "Launch Browser" on the Internet tab does not work. After thinking about it for a while, I realized that the Opera browser was not installed on my device! Now, as far as I know, it should come already in all devices. So, I downloaded the Opera 9.5 browser off their website. How can I set it up so when I tap "Launch Browser" on the Internet tab, Opera 9.5 will automatically run? Currently tapping it still does nothing.
Second is, I've been hearing about this "Windows" folder in the HTC Touch Pro. I can't seem to locate this. When I browse for it with my computer, the name of the TP's "hard drive" is "\", and then I see the following folders:
Application Data, ConnMgr, Content, Documents and Settings, Music, My Documents, Program Files, cemail (hidden file), pim
Is this root folder the "Windows" folder?
Third thing is, in the "Programs" tab in TF3D, there's this icon there that when I press (looks like the default icon for a folder in Vista), it gives me an error. It says "The file 'wt5jetpr' cannot be opened. Either it is not signed with a trusted certificate, or one of its components cannot be found. If the problem persists, try reinstalling or restoring this file."
There we go, that's all. Thank you, if you've read this far.

I can't help with the Opera thing but as for your Windows folder, it's a system file and hidden. You will have to unhide it in your Vista/XP operating system before you can see it using your PC>

You see, I already enabled the viewing of hidden folders. There aren't any other items other than the ones I listed.
EDIT: I tried creating a folder called "Windows" and Vista tells me I can't, because a folder of the same name already exists.
That's weird.. hidden folders are already enabled and I still can't see it.

Hiya, i'm a bit of a noob myselft with regards to wm6.1 so for the opera issue i dont think i could be much help with that same with the file that wont delete so i hope someone else will answer that, to see ur windows folder though when the phone is connected to the pc open up explorer on ur pc and click on tools/folder options then click on view and make sure either the "hide protected operating system files" box is unchecked &/or the "show hidden system files box is checked and this should let you see the windows folder.
Hope this helps.
EDIT: looks like someone already answered in the time it took me to type that, my own fault for multitasking ...

FireGX said:
Second is, I've been hearing about this "Windows" folder in the HTC Touch Pro. I can't seem to locate this. When I browse for it with my computer, the name of the TP's "hard drive" is "\", and then I see the following folders:
Application Data, ConnMgr, Content, Documents and Settings, Music, My Documents, Program Files, cemail (hidden file), pim
Is this root folder the "Windows" folder?
Click to expand...
Click to collapse
Same thing as you, when I browse to the device from Windows Explorer.
However, if I go to Tools - Folder Options - View tab and I select "Show hidden files and folders", the Windows directory is displayed.
FireGX said:
Third thing is, in the "Programs" tab in TF3D, there's this icon there that when I press (looks like the default icon for a folder in Vista), it gives me an error. It says "The file 'wt5jetpr' cannot be opened. Either it is not signed with a trusted certificate, or one of its components cannot be found. If the problem persists, try reinstalling or restoring this file.
Click to expand...
Click to collapse
By the name, it looks like it is JetCet Print 5.
Strange you have these errors. Do you use a custom ROM?
PS: been too slow to answer too. but at least the answers match ;-)

I'm not using a custom rom =\. The rom came with my device.
It's:
1.90.405.1.WWE
It's a HTC Touch Pro T7272

Then I advise you to do a Hard Reset. Opera and JetCet print should be there, and should not give you any certificate errors.
I advise you to read a lot these forums, gather as much info as you can, and experimenting with your device. You have a powerhouse in your hands, you know? you have unlimited possibilities. Any questions should you have must be asked.

Alright, I'll give that a try tomorrow after the day's gone so I have lots of time to figure things out.

Sorry for the double post, but I figure this message won't get read if I simply edit my last post.
Anyways, I hard resetted the device and I got Opera and that printing program working! Thanks creiz.
Just one last thing I'm trying to figure out.. is there any way I can get a custom alarm ring tone without downloading a program? (I'm trying to avoid having to do that if possible)

Remove software reg key HELP

Hi all,
I'm having some isues with an aplication I instaled some time ago. It was a trial version and it has expired, but now I have the registed version to install and every time I install the app it says "0 days".
It should be some app key around, but I can't find it.
Normaly where the keys are stored?
PS: I allready run the SKtools cleaner and removal, and no luck!
Any help would be apreciated.
Prog is CarCare mobile

Ok, this is a little confusing. So, have you ever successfully registered the product? If not, my guess is that you messed up the owner info when you bought it. The registration keys are normally tied to your phone's owner info. If you have Bob J. Smith listed as owner on the phone, then when you bought the app, you needed to have that name listed exactly for the device id (or whatever they call it). I've screwed this up many times. Sometimes you don't realize you're filling out the owner name field when you do it; instead I'll put in my device name (touch pro).
Anyway, find the e-receipt and it should have the owner name and password on it. If it's the only paid-for app that you have, you may just be able to alter your owner name (like remove/add punctuation) to get the reg key to work.
Usually, registration codes are stored in the registry (like HKCU\Software\name of software company or in the HKLM\Software registry). Sometimes, they are put into a text file or something similar that is stored in either \windows or in the \program files folder. And sometimes, there is no registration needed-they just give you a .cab that you install. I will say, I bought Flash Format a couple months ago, and it comes with a desktop installer and you enter the password on your pc during installation. I've tried like a mutha but have been completely unable to find where the registration info is stored, which is a PITA.
Note: registration and registry are two different beasts, but are commonly shortened to reg, which can be confusing.

Farmer Ted said:
Ok, this is a little confusing. So, have you ever successfully registered the product? If not, my guess is that you messed up the owner info when you bought it. The registration keys are normally tied to your phone's owner info. If you have Bob J. Smith listed as owner on the phone, then when you bought the app, you needed to have that name listed exactly for the device id (or whatever they call it). I've screwed this up many times. Sometimes you don't realize you're filling out the owner name field when you do it; instead I'll put in my device name (touch pro).
Anyway, find the e-receipt and it should have the owner name and password on it. If it's the only paid-for app that you have, you may just be able to alter your owner name (like remove/add punctuation) to get the reg key to work.
Usually, registration codes are stored in the registry (like HKCU\Software\name of software company or in the HKLM\Software registry). Sometimes, they are put into a text file or something similar that is stored in either \windows or in the \program files folder. And sometimes, there is no registration needed-they just give you a .cab that you install. I will say, I bought Flash Format a couple months ago, and it comes with a desktop installer and you enter the password on your pc during installation. I've tried like a mutha but have been completely unable to find where the registration info is stored, which is a PITA.
Note: registration and registry are two different beasts, but are commonly shortened to reg, which can be confusing.
Click to expand...
Click to collapse
Thanks for the explanation, I have found that now, and its now working.
It was a problem with the license key, the ID was not matching in my HTC diamond

games into games folder

hi there i've installed some games onto my HD2 (uno, FM, tonyhawks) and want to locate them in the games folder not in the main windows area. can anyone help me do this?

open file explorer. browse to windows/startmenu/programs.....look for ur games shortcuts......cut..... nd paste in windows/startmenu/programs/games. done

You're not done at all.
OK, it will move the shortcut to the correct folder, but the icon won't follow. It's defined in the registry ([HKLM\Security\Shell\Startinfo\Start] then the folder name, then the shortcut name, string value "Icon").
People making CABs should be a bit less lousy and direct shortcuts to the correct folder, same for the acompanying icon.
Actually, some people put icon definitions into several registry keys, so they will "follow" the shortcut if you move it. It's actually a satisfying alternative, if you consider it gives the user the ability to put the shortcut wherever he wants (including copying it to several locations) without losing the icon.
But yes, having shortcuts piling up into the Start Menu's first level, or even worse, placing them into dummy folders with a fixed name (sometimes in a foreign language), is pig work, and I saw even worse (yes, it's possible !) : shortcuts landing to a foreign language "Programs" or even "Start menu" folder, so actually not even displaying in the Start Menu !
When you create (or modify) a CAB file, you should heavily use aliases in order to let Windows Mobile translate them to the actual names during installation.
For instance, if you wanted to direct a shortcut to the "Games" folder, whatever its actual name in your own language is, you should NOT put it into "\Windows\StartMenu\Programs\Games" (neither into "%StartMenu_Programs%\Games", though it's still better like that), but you should actually use "%StartMenu_Programs_Games%", which will put the shortcut in the exact correct location.
You can do the same for the program's location itself. For instance, %ProgramFiles_Games% will direct it to the correct folder, according to your system's language, and will even do so, either you choose to install it on the internal memory, or on the SD card.
You can use these aliases inside registry values, too.
Unfortunately, this process may sometimes do it "too much".
It's the case on cooked ROMs, where the author may retain WWE names for some folders and translate others, sometimes using his own syntax. Since the CAB will always translate using the official way, it may still land in an incorrect location...
The ony way to be sure you'll obtain the wanted result, anyway, is to get some CAB editor program and peek inside before copying them to the pocket PC and installing them... And maybe, fix them before using them.
It will be handy each time you'll need to reinstal it, so don't mind inspecting and fixing the CABs you find : it's always better than crashing your system because something wrong or inadequate to your setup was put inside.
One classic case is TouchFlo / Sense tabs, for instance.
Unfortunately, they're all defined inside a unique XML Manila file, so you actually can't just ADD a tab : in fact, this notion does not even exist ; all you can do is overwrite your whole tabs list with another complete one, and pray that you'll end up with the same list, plus the new one... Would you bet your life on that ? I won't.
In real life, you really can NEVER trust a CAB intended to add a tab to your existing setup, as the author most probably don't have the same tabs as you have. In the best case, you'll just loose some tabs (they'll just disappear, even in the tabs list from the settings, and you won't get them back) : the programs and files are still there, but their definition file will have been replaced by the new one. And in the worst case, it will add a definition for a tab whose programs and files are not previously installed on your phone - and you'll crash it once and for all.
That's the reason why now, I never give a tab CAB containing any tabs definitions. I only provide all but the tabs list, and provide separate CABs for all the possible tabs combinations - and you have to choose and use the good one. Or use Maltwater's SenseUtil program to setup your tabs. The good news is my method will setup all the tabs in perfect order as soon as you've soft resetted the device, since my CABs contain the XML file, plus all the registry keys, plus it resets ManiFull.xml.
So, people, whatever I said about good CABs putting the shortcuts where they should... OK, you may be lucky... But the right behaviour should always be to look inside CABs before trying them. You can trust me !

i'm new coming nice to know all

russeini said:
open file explorer. browse to windows/startmenu/programs.....look for ur games shortcuts......cut..... nd paste in windows/startmenu/programs/games. done
Click to expand...
Click to collapse
It's been a while since I had the need to move icons, so there may be newer versions of this program, but the JWMDIconChanger will move the icons for you.

[Q] Skydrive unusable from Office Hub - docs.live-tst.net

Hi all,
I've been having trouble with SkyDrive in the Office hub ever since I bought an Omnia 7 in september. I've tried various Microsoft forums and answers.microsoft.com, but so far there has been no helpful response. I have however found someone else with this exact same problem and no solutions.
The problem seems to be that the Office hub wants to connect to some sort of test version of SkyDrive. I derive that from the following behaviour:
- In the Office hub i go to the Locations page and tap on SkyDrive.
- It goes to a page titled SkyDrive, and immediately pops up a "SIGN IN" dialog where my Live account is already filled in. It has 2 buttons: sign in / cancel.
- I tap "sign in".
- It says "refreshing view" with the blue running dots for a second, then pops up an error: "Something's wrong. We encountered a problem and couldn't complete this task." This dialog has 1 button: "Ok". I tap it.
- Now at the top where it said "SkyDrive", it now says "DOCS.LIVE-TST.NET"
At any point in the Office hub where it's supposed to connect to skydrive it shows me the login dialog followed by the error.
If i tap and hold a notebook and view the synchronisation status it says: "There was a problem and we couldn't complete this task. Try again. Error code: 80078862". I've googled this code and found nothing.
An often recommended fix for other SkyDrive problems is to open the SkyDrive website thru the browser on the phone, and then open a note or notebook so it fires up the application. If i try this i get a different error: "Can't open link. OneNote doesn't support this server version and can't open the requested content."
I've tried the obvious "reset office from the settings menu".
This all leads me to believe that somewhere there is a setting in the Office hub that makes it only want to connect to this (test-version?) of SkyDrive called docs.live-tst.net.
Since today I have used this WindowBreak method, so now I'm hoping someone can suggest a way to fix this, maybe by accessing certain registry keys that determine the URL's the Office hub tries to connect to.
Any other help or suggestions is obviously also welcome.
EDIT: Solved! See post #4 for details.

I have had problems where the SkyDrive only works sometimes. When it works it's great but when it sucks, boy does it suck. I have never been a fan of the cloud service and this one of the reasons why. Also when I try to pull my epubs from Skydrive using Freda; it just crashes. WTH is wrong with just giving us access to our damn system folders and letting us store our stuff on the phone like in Windows Mobile. At this rate Windows Phone will always be in third place.

Well if it'd work properly I might be really happy with SkyDrive, but with the problems it's giving me it's hard to say.
I was hoping to sync a notebook with grocery lists with my gf, but I'm forced to use Google Docs now.

Well, fixed it with a combination of WindowBreak and WP7 Root Tools and fiddling in the registry.
In the path local machine/software/microsoft/office mobile/skydrive/ I have changed the following keys:
SkyDriveServer from value "docs.live-tst.net" to "docs.live.net"
SkyDriveServerForURLParsing from value "live-tst.net" to "live.net"
SkyDriveServerForURLParsing-INT from value "live-tst.net" to "live.net"
SkyDriveServerForWEBURLParsing from value "skydrive.live-int.com" to "skydrive.live.com"
SkyDriveServerForWEBURLParsing-INT from value "skydrive.live-int.com" to "skydrive.live.com"
SkyDriveServer-INT from value "docs.live-tst.net" to "docs.live.net"
I can happily report that everything seems to sync now. The folder structure of SkyDrive and its notebooks is still a mystery to me, but that's not part of the problem I was having.
It does make me curious how I ended up with the not-working settings in the first place.