OS X V10.7 Lion :: Excel Alias Dropbox Incompatibilities?
Jun 9, 2012
OSX 10.7.4 with Excel 14.2.2.(for Mac 2011) and Dropbox:Â Original files are saved in Dropbox folder on Mac; Aliases are created there and stored local on Mac HD. Using Finder and navigating to Alias works fine; files open, can be modified and resaved. However, using Excel File Open command and navigating to the same Alias results in "File Not Found or Could Not Be Opened" error message.
Info:
MacBook Pro (13-inch Mid 2009), Mac OS X (10.7.4)
I want to create stacks for my Applications and put them in the dock by type. Utilities, Music & Video, iLife, etc. I think what I will do is make aliases for all the applications and put them in subfolders separate from the Applications folder, so then I have these 3-6 subfolders in my dock as stacks that I can display in Grid or Fan mode. And I don't have to see all my applications in one jumbled Grid and search for them.
Yes, I know Spotlight or QuickSilver could access them differently.
My question is, when I have created this duplicate system with the aliases to the apps, how do I remove the Alias (arrow) portion of the icon so that they look just like the actual icon down in the stack (or in my subfolders, etc)?
 I downloaded Dropbox and the Finder has crashed by blinking with the "restore windows"-window. Then I created another administrator account and from here deleted Dropbox. Then restarted and logged in to my normal account. Now Finder wasn't blinking like before but there is nothing viewable on the Desktop and when I click on Finder in the Dock several times it comes up with a window for a splitsecond then closes the window again. Then I can press it several times again and it comes up for a splitsecond and then closes again. When hitting the command-option-esc, the icon blinks here. I've actually also tried the killall Finder in terminal, but even this doesn't work.
I am having some trouble with some new iMacs that are running Lion. Sometimes they will turn a file into an alias. It replaces the original with the alias and will not allow me to access the file any longer like the original is completely missing. It seems to be random, it does not happen to one type of file or any one program. It has happened on our servers (when copying pdfs and saving indesign files) and also locally. I was able to find a temporary fix by downloading path finder and unchecking the "alias bit" option. This seems to fix the issue at hand, but I need a more permanent solution, or at least something I can tell my users to avoid doing.
I have several Alias Icons on my desktop which are unable to be removed. I have tried changing the rw permission and reselecting the original appliaction etc. But still unable to delete these alias icons. can someone point me in the right dircetion to use Terminal command such as rm -f file name to permanetely remove these left over icons. Before OS X Lion 10.7 I was able to chmod etc and delete the icon.
Why are alias files so big now? Before (OSX 10.3), they were rarely bigger than 1 KB, but now (OSX 10.7), they're often up to 1.6 MB! Can we do something to keep them small?  As I understand it, an alias is just a pointer or reference to another file. When you open or print it, the operating system actually opens or prints the original file referenced. All that needs to be stored is the directory path to the original file, either (or both) as a full reference or a relative reference, plus its file system ID and perhaps a drive ID (in case it's moved). This should take only a few bytes. On prior Mac operating system versions (e.g., 10.3.9), these alias files were just a few hundred bytes in size, rarely over 1,400 bytes total. But now I notice that, under Mac OS 10.7, newly created alias files are always hundreds of KB large, and can typically be as huge as 1.6 MB! The custom icon only accounts for a fraction of this size. However, sometimes they can still be as small as before (only a few hundred bytes). Old aliases from a prior OS version (usually but not always) still work in opening their original file, so apparently we don't need the extra size. So, what is in these files?! I know these are analogous to "shortcut" files under MS Windows, which are not that large.  Having aliases be so huge defeats the purpose of a small file reference that can be used in multiple other places. One would like to use an alias so as to not have to keep a copy of a large file. But I notice that MB-sized aliases are often created even when the original file is a tiny 1 KB file. Moreover, a larger original file might create a smaller alias than that for a smaller original file, even when both original files are in the same folder. What gives?  I use aliases extensively, so as to keep references to the same original file in multiple folders, since these files fall into the multiple categories that each folder contains. By using aliases, I ensure that there is only a single "master" version that is edited when a file is opened from any of those folders. Many of the original files are pretty small, yet their aliases are many orders of magnitude bigger. This is very discouraging towards using this handy feature. Is there something I am doing wrong to end up making them so big – perhaps a system setting? What is in these files that they need to be so huge? I suppose I can use Unix symbolic link files by using a command line in Terminal, such as 'ln -s originalfile linkfile', but these are less functional, since you can't move or rename the originalfile without breaking the linkfile's association to it.Â
I recently noted that accented characters are lost in long name description of email alias address when using Mail.app but ok when using webmail in iCloud.com Setup in the prefs of the master mail account in iCloud, the long name description for the corresponding alias.is transcripted as "Frdric" in Mail.app when selecting the sender address in the dropdown list box.However, all is fine when using webmail within iCloud.com The problem appears only with OSX not with iOS.
I have been using my alias with accented char in its long name description for the last 4 years with Leopard, Snow Leopard and Lion until recently. I can replicate on 3 differents Macs. Even tried to create a new user account.
I am creating 2 AppleScripts to automate mounting Windows shared drives on Lion Macbook Airs. The first creates an alias on the user's desktop to the user's shared drive. This is functional and doing what I want it to do. The 2nd script attempts to create a favorite to the alias in Finder's sidebar. Unfortunately, I can't seem to get this script to work.Â
I am attempting to create an alias on a user's desktop to a folder in a Windows network share.Here is my applescript: set user_name to (short user name of (system info))tell application "Finder" activate set myFolder to ((home as text) & "Desktop:" & user_name)select myFolder tell application "System Events" keystroke "t" using command down end tellend tell The script runs, Finder opens to the user's folder, but nothing is added to the side.Â
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
In Excel for Mac (Office 2011), simple copy-paste operations can take a few seconds even with small files with no complex content. Sometimes Excel files also take very long to open.
I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
I am contemplating upgrading my MacBook Pro (2011 model) from Snow Leopard to Lion. I am concerned about the level of strong criticism about Lion, especially the comments that MS Word and Excel (and Powerpoint?) cannot run in Lion. What is the full story? Can I run MS Office products by reloading them into Lion environment?
Excel is opening closed files from prior sessions when I log into my Mac Pro on Lion. I want excel to launch at log in, but I don't want it opening a lot of files that I have no interest in and since they are big, they take a lot of time to open. I haven't been able to find the setting that will eliminate this problem. Does anyone have any information about whether there is a setting or whether this is "a Feature"?
has anyone had an issue with office mac 2011 excel and osx lion? i make excel spreadsheets with pdf storyboards on them, and too often the excel file will not reopen. instead i get a corrupt file notice. i choose fix file and the file opens without the pdf files. sounds like a pdf/excel issue to me. it is maddening.
I installed SL 10a432. Transferred a lot of files to the share/dropbox. In swedish this is called: ~/Delad/Brevl�demapp/ which in English would translate to "~/Shared/Mailbox folder/" or something similar, it not related to emails, just the literal translation....
what should I write in spotlight to reach this folder? i have tried loads of combination but I cannot find this folder in spotlight but I can find the items in it...
if I write "dela" as in "Delad" it suggest "delat" like it would suggest share insted of shared when it in fact was called shared....
The 1password keychain is encrypted, but if I open the keychain file so I can use 1password or to look up info on my keychain on an open unsecure WiFi, could other people see my passwords and secure notes?
I believe read Dropbox stores all files encrypted, but that MobileMe does not encrypt them. Is that correct? But since the 1password keychain is already encrypted it's not necessary to have it stored encrypted like on Dropbox??
I am running a MacBook Pro with OS X 10.7.3 and the latest version of Office 2011 with all the updates installed. Both run very slow and now I noticed that when I click on either icon in the dock it says "Application Not Responding" even though the applications are responding, just very slowly. If I close either application and then reopen it, the message is gone until I open a new document.
my microsoft excel 2011 is not working with the os x lion. why is it so? whenever i try to to open it it will automatically close.. and a report will popo up and say microsoft excel cannot be opened because of a problem, should i reinstall my excel then?
